The onpsm utility for storage management

Use the onpsm utility to manage the HCL OneDB™ Primary Storage Manager catalogs, devices, locks, and objects.

Pre-requisite: To run the onpsm utility, you must be user root or informix.

Syntax

>>-onpsm--+-+-| Catalog options |-+-+--------------------------><
          | +-| Device options |--+ |   
          | +-| Object options |--+ |   
          | '-| Pool options |----' |   
          +--- -h ------------------+   
          '-+---------------+-------'   
            +- -V ----------+           
            +- -version-----+           
            '- -version all-'           

Catalog options

|-- -C -+-check--+-----+-----------+----------------------------|
        |        +- -l +           |   
        |        '- -n '           |   
        +-+---------+--------------+
        |  'backup---location-- --creds ---credentials_file|
        +-+---------+--+---------+-+ 
        |  'restore---location-- --creds ---credentials_file|
        +-+---------+--+---------+-+    
        | '- detail-'              |   
        +-+---------+--+---------+-+   
        | '- export-'  
      +- import + |   
        |              '- -y ----' |   
        +-+----------+-------------+   
        | +- init ---+             |   
        | +- init -d +             |   
        | '- -y -----'             |   
        '-+---------+--------------'   
          '- unlock '                    
   

Device options
|-- -D -+-add--path-- -p -priority-- -g -pool_name-- -t -type--+-----------+-- -b -block_size-+--|
        |                                                      '- -s -size-'                  |   
        +-del--path--+- -g -pool_name--+-----+-+----------------------------------------------+   
        |            |                 '- -y ' |                                              |   
        |            '- -d -+-----+------------'                                              |   
        |                   '- -y '                                                           |   
        +-list--+- -u ------------------+-----------------------------------------------------+   
        |       '- -l -dev_def_file.txt-'                                                     |   
        +-purge--path-------------------------------------------------------------------------+   
        +-scan--path--------------------------------------------------------------------------+   
        '-update--path--+---------------+--+-----------+--------------------------------------'   
                        '- -p -priority-'  '- -s -size-'        
                                   
Object options

|-- -O -+-del-- -o -object_id--+-----+-+------------------------|
        |                      '- -y ' |   
        +-detail-- -o -object_id-------+   
        +-dump-- -o -object_id---------+   
        '-list-------------------------'   

Pool options

|-- P -+-add--pool_name----------+------------------------------|
       +-del--pool_name--+-----+-+   
       |                 '- -y ' |   
       '-list--------------------'

Table 1. onpsm utility catalog options
Element	Purpose	Key Considerations
-C check	Checks storage manager catalog tables, which store metadata about the pools and devices that the storage manager manages	This command identifies files that have problems.
-C check -l	Displays index keys while checking the catalog tables
-C check -n	Indicates that the storage manager does not fix errors that are found
-C detail	Shows details about the storage manager catalog tables
-C export	Exports the OneDB Primary Storage Manager catalog tables to a directory called psm_catalog.exp
-C import	Replaces the current OneDB Primary Storage Manager catalog with a catalog that is recreated from files that are in the psm_catalog.exp directory	Only import the catalog if you have a system problem, lost your current catalog, and need to revert to the exported catalog. If you need to import a catalog, run the onpsm -C init command before you run the onpsm -C import command.
-C init	Deletes storage manager catalog tables
-C init -d	Deletes storage manager catalog table and the backup objects in file devices
-C unlock	Unlocks the storage manager catalog	If the storage manager exits abnormally from a backup or restore session because a failure occurred, storage manager catalog tables might remain locked. If catalog tables are locked, you can release the locks.
-y	Specifies to not to ask for confirmation before deleting catalog tables

Table 2. onpsm utility device options
Element	Purpose	Key Considerations
-D add	Adds a device to the pool specified with the -g option	Before adding devices, gather information about the device. See Collecting information about file directories and devices.
-D del	Removes a device: If you use the -g option, removes a device from the pool specified with the -g option, while retaining the device objects in the OneDB Primary Storage Manager catalog. If you use the -d option, removes the device from all pools and removes all backup objects from the file system in that device	If you delete the device using -g option, you can restore the objects if necessary. If you remove a device, the storage manager cannot add new objects to the device.
-D list	Displays a list of all devices in the system
-D purge	Removes missing storage manager objects from the OneDB Primary Storage Manager catalog
-D scan	Scans objects in the device to verify that the objects exist in the OneDB Primary Storage Manager catalog so the objects can be restored if necessary If an object is not in the catalog, this command adds the object to the catalog.	If the command cannot add an object to the catalog, the command ignores the missing file. Before a missing object can be added to a catalog, the following conditions must occur: The object ID must not be assigned to any other object in the storage manager. Files must not be renamed or relocated to different directories inside the device The object version must not be assigned to any other object in the storage manager.
-D update	Modifies information about a device	If you want to modify information about more than one device, run a separate command for each device.
`path`	Full name and path to the device (for TAPE devices) or to a directory (for FILE devices)	The path must be in the format appropriate to the operating system to which the device is attached . The name of the device must be unique within a pool. You can include the same device in multiple pools. If you are deleting, listing, purging, scanning, or updating information, the path must be to an existing device.
-b `block_size`	For tape devices only, the minimum number of bytes of data that need to accrue before the data is written to the device	The block size is required for tape devices.
-d	Deletes the pool from all pools and deletes backup objects	The block size is required for tape devices.
-g `pool_name`	The pool in which to add the device, either DBSPOOL, LOG POOL, or EXTPOOL	Information about pools is stored in the OneDB Primary Storage Manager catalog. If you do not provide a pool name, the command fails. Specify: DBSPOOL for backups of dbspaces, blobspaces, and sbspaces LOGPOOL for backups of logical logs EXTPOOL that serves as a staging area from which you can move specific backups or backup generations to permanent storage or onto a different computer.
-l `dev_def_file.txt`	Loads information about the device from a device-definition file
-p `priority`	Priority of the device, either HIGHEST, HIGH, LOW, or READ-ONLY	The storage manager fills high-priority devices in a pool before placing data into low-priority devices in that pool. If the high-priority devices are busy at the moment when the storage manager is ready to fill a pool, the storage manager uses low priority devices. Only one device in a pool can have the priority of HIGHEST. If multiple devices have the same priority in the same pool, the storage manager determines which device to use first. When a device becomes full, the storage manager changes the priority to READ-ONLY. You can change the priority after you add more space to the device.
-s `size`	For tape devices only, the maximum storage capacity of the device in kilobytes	The size is optional for tape devices. If a size is not specified, or if you specify `0`, the storage manager interprets the size as unlimited. When the size is unlimited, the device is not considered full until it returns an error that specifies that the device is full. To specify the size enter the numeric value of the size followed by the suffix B, K, M, G, T, or P (for bytes, kilobytes, megabytes, gigabytes, terabytes, or petabytes). The suffix can be upper or lowercase.
- t `type`	Type of device, either FILE or TAPE	Information about devices is stored in the OneDB Primary Storage Manager catalog,
-u	Unloads information about the device to a device-definition file	The device definition file is a text file with a specific format. The storage manager uses the file to recreate the information when you run an onpsm command with the load option.
-y	Specifies not to ask for confirmation to complete the requested action

Table 3. onpsm object options
Element	Purpose	Key Considerations
-O del	Deletes physical objects from a pool
-O detail	Displays details about the specified object. Details include the location of the object.
-O dump	Extracts the object data to a file in the current directory
- o `object_id`	Identifies the particular object	You can delete or dump one or more objects with a single command, as shown in Usage.
-O list	Displays all objects in a pool	For each object, the list includes the date and time the object was created, the size of the object, and the path name of the object.
-y	Specifies not to ask for confirmation to complete the requested action.

Table 4. onpsm pool options
Element	Purpose	Key Considerations
-P add `pool_name`	Adds a new pool
-P del `pool_name`	Deletes the specified pool
-P list	Lists all pools in the system
-y	Specifies not to ask for confirmation to complete the requested action.

Table 5. onpsm utility general options
Element	Purpose	Key Considerations
-h	Displays help information
-V	Displays the software version number and the serial number	For more details about the standard -V and -version options, see Obtaining utility version information.
-version	Displays the software version number, serial number, and additional information such as the host, operating system, build date, and the Global Language Support (GLS) version	For more details about the standard -V and -version options, see Obtaining utility version information.
-version all	Displays onpsm version information and information about the PSM shared library

Usage

When you run an onpsm command to define a device, the storage manager automatically creates storage manager catalogs if they do not exist.

The default device for the storage manager is $ONEDB_HOME/backups. The device, which is low priority, is automatically created when the catalog is created. You can remove the default device.

When you create a device, the storage manager automatically creates the directory for the device if the directory does not exist. The storage manager uses the directory path that you specify in the onpsm -D add command.

You can delete one or more objects with a single command, for example, by running a command that has this format:

onpsm _O del -o obj_1 -o obj_2

You can also dump one or more objects with a single command, for example, by running a command that has this format:

onpsm _O dump -o obj_1 -o obj_2

If the data is not needed, run the onsmsync utility to delete backup objects from the OneDB Primary Storage Manager.

Some third-party storage managers do not allow the onsmsync utility to delete backup objects from the storage manager. If you have a third-party storage manager, you might need to manually delete backup objects that you no longer need.

Examples

The following command adds a file device with the path name $ONEDB_HOME/backups in the DBSPOOL pool:

onpsm -D add $ONEDB_HOME/backups -g DBSPOOL -t FILE  -p HIGH

The following command checks OneDB Primary Storage Manager catalog tables and indicates that the storage manager does not fix any errors found during the check:

onpsm -C check -n

The following command lists objects in pools, including the date and time the object was created, the size of the object, and the path name of the object.

onpsm -O list