...
This procedure will require a restart of Zend Server, so please schedule it for a time when it is OK for your site to be down for a few minutes.
Please open Navigator and navigate to /usr/local/zendphp74/var/db
Expand the db folder and locate file statistics.db.
Leave Navigator open, and go to your 5250 emulator. From the 5250 command line:
| Info | ||
|---|---|---|
| ||
go zendphp74/zsvmenu |
Use option '2. Stop Zend Server Subsystem'. From the command line at the bottom of the menu:
| Info | ||
|---|---|---|
| ||
wrkactjob sbs(zendphp74) |
Make sure there are no jobs running in this subsystem. If there are any, use F5 to re-display a few times, until the jobs are all gone. When the jobs are all gone, press enter to return to the menu.
Please go back into Navigator. Right click on the statistics.db file and select 'Rename...'. Rename the file to something like statistics.db.old. The name is arbitrary. Just use something so you can recognize the renamed file later when you decide to delete it.
Return to the 5250 emulator, where you should still be on the Zend Server for IBM i Service Menu. Use option '1. Start Zend Server Subsystem'. From the command line at the bottom of the menu:
| Info | ||
|---|---|---|
| ||
wrkactjob sbs(zendphp74) |
Make sure the ZSDAEMON jobs have restarted. If needed, use F5 a few times until the jobs have appeared. These are the jobs you are looking for:
| Info | ||
|---|---|---|
| ||
ZSDAEMON QTMHHTTP BCI .0 PGM-watchdog |
Return to Navigator and use F5 to refresh the display. Verify that there is a new statistics.db file.
After resuming normal operation of your web site, check the /tmp directory to verify that the qt_temp.xxxxx files have stopped proliferating. You may delete the old renamed statistics data base file whenever you like.
Please open Navigator and navigate to /usr/local/zendsphp7zendphp7/var/db
Expand the db folder and locate file statistics.db.
...