Reducing the CPU usage of JQM servers in SAP environment

HP Output Server 3.5 3
Reducing the CPU usage of JQM servers in an SAP environment
Solution
To indicate that this attribute is indexed by the JQM server, the value 3 replaces the dash in the fourth column:
erp-job-retention-period ..1.0.10175.1.0.0.3.1.230 TBSJ 3 pm3 DeltaTime 001
The attribute is updated.
5. Save the DPAOIDs file and exit the text editor.
NOTE: To index attributes for more than one server, combine the digits in the fourth column for
example, an attribute indexed in both the Delivery Manager (DLM) and the JQM server
has a value of 23.
Task 2: Execute the mkoiddb utility.
1. Stop all the delivery servers (DLM, JQM, and DSM) as well as the Configuration Manager (CM) by using the
stop_server command.
2. Execute the mkoiddb utility in the same directory as the DPAOIDs file that you modified in Task 1, by using
the following command:
mkoiddb DPAOIDs
The associated DPAOIDs files (DPAOIDs.dat, DPAOIDs.dir and so on) are created again.
NOTE: Do not start the stopped servers at this point.
Task 3: Execute the dbindex utility.
1. Execute the dbindex utility with the appropriate database connection parameters, such as hostname, port or
socket, user name and password.
NOTE: The user name value must be of a user with administrative privileges.
The syntax for the dbindex utility is as follows:
dbindex -n<server name> -h<hostname> -j<port> | -o<socket> -b<user>
-w<password>
For the above example, the command is:
dbindex -n jqm1 -h localhost -j 3306 -b root -w password.
Depending on the number of records in the JQM server, this command might require several minutes to execute,
because it rebuilds the database of the JQM server.
2. Start the CM and the delivery servers.
The newly designated indexed attribute should now be properly indexed within the job database of the JQM
server.
The dbindex utility can be used to re-index any databases of the delivery servers. However, the current intended
use for the utility is to index attributes for the JQM jobs table because the pdls command is typically used to search
through thousands of records in a jobs table of the JQM server.
NOTE: To gather more information on how to use the dbindex utility, contact your HP
Professional Services representative.