onpsm -C detail output

Use the onpsm -C detail command to view details about the storage manager catalog tables.

Sample onpsm -C detail command output


D:\IFMXDATA\gacpsm>onpsm -C detail

HCL
                    OneDB™ Primary Storage Manager State:

    PSM Unique ID    : 1358735848
    Catalog Location : D:\database\1210\etc\psm\
    Catalog State    : Locked
    Catalog Owner    : 2
    Catalog Lock Mode: Regular

Sessions:
    Session ID       Process ID
    2                1576
    3                4556
    4                5555

HCL
                    OneDB PSM Locked Objects

Session  Object Id Date       Time     Server        Object Name

     3         116 2012-12-09 20:54:34 /gacpsm_tcp   /gacpsm_tcp/168/242
     4         117 2012-12-09 21:07:44 /gacpsm_tcp   /gacpsm_tcp/168/242

The output contains the following sections:

OneDB Primary Storage Manager State

Shows general information about all of the sessions that are active in the system and whether the catalog is locked.

PSM Unique ID: ID for the catalog
Catalog Location: Path to the catalog
Catalog State: Indicates whether the catalog is locked
Catalog Owner: OneDB Primary Storage Manager session ID
Catalog Lock Mode: Lock category
For example, Regular means that the lock is a user lock.

Sessions

Lists all of the sessions that are active in the system and the process IDs that match the sessions.

Session ID: ID of the session. This is the same ID that appears in the Catalog Owner field.
Process ID: Internal ID for the ON-Bar, archecker, or storage manager process that is locking the catalog.

HCL OneDB PSM Locked Objects

Shows the locks in devices or objects that are held by storage manager sessions. For each lock, the output shows the session number, the object ID, the date and time that the lock was placed, the server, and the object name.