The UniVerse DBA

A reference Site for the Rocket ® UniVerse Database Administrator.

General Overview - Page 2
The UniVerse Installation Directory

In the root directory is a "hidden" file named ".uvhome". You can always get to the UniVerse install directory by typing the following:
cd `cat ./uvhome`
Please take note the punctuation marks are "backtics" and not single quotes. Performing this command will take you to the UniVerse install directory. From there,
cd bin
will allow you to review executables used by UniVerse, some of which can be used by the UniVerse DBA. Please consult the Rocket UniVerse Documentation web page (see Link Page) for specific commands useable by a user. There are five commands, though, that need to be mentioned here, specifically. Again, review the documentation for complete details.

list_readu
Syntax:
list_readu [USER terminal#] [EVERY]

Example:
list_readu USER 10 EVERY

smat or analyze.shm
Syntax:
smat (options)

Options list:
-a [userno] (All) Lists information generated by all options. userno specifies a user number. You must be UniVerse Administrator to use the userno argument.
-b (BASIC) Lists the status of all cataloged programs currently loaded in BASIC shared memory.
-c (Configuration) Lists currently active authorization parameters
-d (Dynamic) Lists the status of all active dynamic file control blocks.
-f (File) Lists all active file locks. The UniVerse LIST.READU command also lists this information.
-g (Group) Lists all active group locks. The UniVerse LIST.READU command also lists this information.
-l (Logging) Lists information about the transaction logging subsystem.
-L Lists all NLS locales in shared memory.
-M Lists all NLS character set maps in shared memory.
-n (Numbers) Lists raw, unformatted data for all table entries, including unused entries.
-p [userno] Display shared memory information for the specified user number. Requires UniVerse Administrator privileges.
-r (Readu) Lists all active record locks. The UniVerse LIST.READU command also lists this information.
-R (Replication) Lists information about the state of U2 Data Replication.

Example:
smat -r

port.status
Syntax:
port.status [USER name] [PORT number] [DEVICE pathname] [PID process#]
[FILEMAP] [LAYER.STACK] [MFILE.HIST] [LOCK.HIST] [{ENABLE | DISABLE}
LOCK.HIST] [ODBC.CONNECTIONS] [LPTR] [RUNNING] [SUSPENDED]

Example 1:
port.status LAYER.STACK
Example: 2
port.status PORT 10 LAYER.STACK

listuser
Syntax:
listuser [-i | -n] [-a] [-t] [INTERNAL] [[options] value] [TERMINAL | PHANTOM | ME]

Example 1:
listuser PID 25161

uvlictool
Syntax:
uvlictool [check_acctlic] [list_acctlic] [ reload_acctlic] [report_lic [logical_account_name]] [clean_lic [-a]]

Example 1:
uvlictool report_lic
Example: 2
uvlictool clean_lic -a