HPOS 4.0 technical note 1

HP Output Server 4.0 1
Technical Note
Using dbmod utility
HP Output Server uses Character Large Object (CLOB) to store all the attributes of HP Output Server databases.
Some of the HP Output Server attributes are indexed and are stored in CLOB. HP Output Server database CLOB data
is represented in XML format. The dbmod utility moves an attribute or set of attributes from the CLOB and make it
to indexed or non-indexed column and viceversa.
By default, the HP Output Server installation’s most frequently updated or accessed attributes of HP Output Server
are moved out of the CLOB and stored as indexed and non-indexed columns.
Advantages
The following are the advantages of moving the attributes out of the CLOB:
• The CLOB data is easily accessible.
• Optimized database operations by accessing the CLOB only when required.
DBmod Utility
Perform the following steps to use the dbmod utility:
1. Stop all or a specific HP Output Server to which the required attribute needs to be moved into or outside the
CLOB by executing the following command:
stop_server -t all
NOTE: The servers include DSM, DLM, JQM, or CM.
NOTE: The dbmod utility is not required for DSM server and you need to restart the server.
NOTE: Ensure that the MySQL database server must be running before using the dbmod utility.
Example: stop_server -t dsm
2. Identify the attribute(s) to be taken out of CLOB or moved in to CLOB and modify the DPAOIDs file as follows:
- If an attribute has to be indexed, enter the value for the corresponding server in the 4th column of the
attribute entry of the DPAOID file.
- If an attribute has to be moved to a non-indexed column, enter the values for the corresponding server in the
11th column of the DPAOID file.