Launching soon: The world's first vendor agnostic bug scrubLearn more & join waitlist
OPERATIONAL DEFECT DATABASE
...
...
Document Version Release Date Details 2 12/18/2020 Updated advisory with detailed steps in Resolution. 1 11/24/2019 Original document release The Global Workload Management (gWLM) Software gWLM database size increases over time and the gWLM history purge or truncate options do not reduce disk usage on an HPE Integrity system running HP-UX 11.31. Note (1) : gWLM is a software that allows centrally defining resource-sharing policies that can be used across multiple HPE servers. These policies increase system utilization and facilitate controlled sharing of system resources. gWLM's monitoring abilities provide both real-time and historical monitoring of the resource allocation. The command 'gwlm' is available with HPE Global Workload Manager that manages workloads on both HP-UX and Linux. For example, the purging history data before June 1, 2016 did not result in file system space released as shown below: # bdf Filesystem kbytes used avail %used Mounted on /dev/vx/dsk/rootdg/varvol 38797312 14770616 23859808 38% /var /dev/vgsim/lvsim 52396032 47235848 5119920 90% /var/opt/hpsmdb# sudo gwlm history --purge=1576 Removing data that was stored before "2016/06/01:21:38". # bdf Filesystem kbytes used avail %used Mounted on/dev/vx/dsk/rootdg/varvol 38797312 14770640 23859784 38% /var /dev/vgsim/lvsim 52396032 47235848 5119920 90% /var/opt/hpsmdb Note (2) : The gwlm command completed without any errors but the disk utilization was not reduced.
Any HPE Integrity system running HP-UX 11i v3 and HPE Global Workload Manager A.7.x.
Below are the steps to perform a full vacuum on the gWLM database to recover diskspace after executing purge or truncate commands. For more information about the commands used in the procedure, refer to the corresponding command man pages and/or related gWLM documentation. Backup gWLM database and configurations by typing the following commands: # vseinitconifg -b -d /path/backup_dir # gwlm export --all --file=/backup_dir/gwlm.config # gwlm list Stop Capacity Advisor, gWLM, HPE SIM, and HPSMDB by typing the following commands: # /opt/amgr/bin/cms_stop # /opt/gwlm/bin/gwlmcmsd --stop # mxstop # /sbin/init.d/hpsmdb stop Delete the old history from gWLM database. e.g. To delete data older than 1000 days, type the following command: # gwlm history --purge=1000 Grant permission temporarily to access gWLM database to clean up disk space by performing the following: a) Backup the hpsmdb configuration file by typing the following commands: # cd /var/opt/hpsmdb/pgsql/ # cp -p pg_hba.conf /var/opt/hpsmdb/pg_hba.conf.orig b) Edit the "pg_hba.conf" and change "md5" to "trust" for required gWLM database. Save and exit from the file. For example: To change gWLM database access permission. Change: host gwlm gwlmadmin 127.0.0.1/32 md5 To: host gwlm gwlmadmin 127.0.0.1/32 trust c) Start the HPSMDB by typing the following command: # /sbin/init.d/hpsmdb start Perform FULL VACUUM of gwlm database after history data clean up by typing the following command: #/opt/hpsmdb/pgsql/bin/vacuumdb -h 127.0.0.1 -U gwlmadmin -p 50006 -f -d gwlm Note : The full vacuum may take one to two (or more) hours, depending on size of database). Activity can be monitored with "sar -L 1 10" and "top" commands. Use "bdf" to monitor disk space released by the command. Restore HPSMDB access security and delete the configuration copy by typing the following commands: # /sbin/init.d/hpsmdb stop # cp -p /var/opt/hpsmdb/pg_hba.conf.orig /var/opt/hpsmdb/pgsql/pg_hba.conf # rm /var/opt/hpsmdb/pg_hba.conf.orig Start HPSMDB, HPE SIM, gWLM, and Capacity Advisor, and HPSMDB by typing the following commands: # /sbin/init.d/hpsmdb start # mxstart # /opt/gwlm/bin/gwlmcmsd # /opt/amgr/bin/cms_start Restart gWLM and WBEM on clients by typing the following commands: # /opt/gwlm/bin/gwlmagent --restart # cimserver -s ; cimserver Re-deploy the gWLM SRD from UI or command line. Additional information is in Information in the HPE Global Workload Manager 7.6 User Guide # gwlm deploy --srd=SRD Verify everything is working properly in HPESIM and gWLM. If any error is observed during above process. Restore the database and configuration. To restore GWLM database and configuration from the backup taken in Step 1, type the following commands: # vseinitconifg -s -d /path/backup_dir -F # gwlm import --file=/backup_dir/gwlm.config --clobber Execute Step 2, Step 7, and Step 8 to restart all relevant services. RECEIVE PROACTIVE UPDATES : Receive support alerts (such as Customer Advisories), as well as updates on drivers, software, firmware, and customer replaceable components, proactively via e-mail through HPE Subscriber's Choice. Sign up for Subscriber's Choice at the following URL: Proactive Updates Subscription Form. NAVIGATION TIP : For hints on navigating HPE.com to locate the latest drivers, patches, and other support software downloads for HPE systems and Options, refer to the Navigation Tips document . SEARCH TIP : For hints on locating similar documents on HPE.com, refer to the Search Tips Document . To search for additional advisories related to HP-UX, use the following search string: +Advisory +ProLiant -"Software and Drivers" +HP-UX +Integrity