Issue

There may be no new Events displayed in the Zend Server User Interface.  Or, it may not be possible to view Events in the Zend Server User Interface.  Instead, an error similar to this might be seen:

Zend Monitor can not access the issues database

Environment

Any version of Zend Server for IBM i running on any version of IBM i.

Resolution

The Monitor data is kept in a SQLite data base file.  This file may become corrupt. It can be regenerated by removing or renaming the file, cycling the Monitor daemon, and then restarting PHP. Note that all old events will be lost. This procedure will make your web site unavailable for a few minutes, so please schedule for a suitable time when maintenance can be done.

Step 1: Delete or rename this file:

NOTE: If there is a file named monitor.db-journal in the same directory, please also delete this file.


For Zend Server version 2020 or higher, this is the file:

/usr/local/zendphp74/var/db/monitor.db

For Zend Server version 9.1.-2019, this is the file:

/usr/local/zendphp7/var/db/monitor.db

For Zend Server version 6-8.5, this is the file:

/usr/local/zendsvr6/var/db/monitor.db

For Zend Server version 5, this is the file:

/usr/local/zendsvr/var/db/monitor

This is easiest to do using iSeries Navigator, the Zend Studio Remote Systems perspective, or a mapped network drive.

Step 2: Stop and start the Monitor daemon. From a 5250 command line:

For Zend Server version 2020 or higher:

GO ZENDPHP74/ZSMMENU

For Zend Server version 9.1-2019:

GO ZENDPHP7/ZSMMENU

For Zend Server 6-8.5:

GO ZENDSVR6/ZSMMENU

For Zend Server 5:

GO ZENDSVR/ZSMMENU

Use option '2. Stop Monitor'.

Then, on the command line:

For Zend Server version 2020 or higher:

WRKACTJOB SBS(ZENDPHP74)

For Zend Server version 9.1-2019:

WRKACTJOB SBS(ZENDPHP7)

For Zend Server 6-8.5:

WRKACTJOB SBS(ZENDSVR6)

For Zend Server 5:

WRKACTJOB SBS(ZENDSVR)

Make sure there are no jobs named 'ZSMONMNG'. Use F5 to redisplay until the jobs are gone. Then use F12 to return to the menu.

Use option '1. Start Monitor' Then, again from the command line:

For Zend Server version 2020 or higher:

WRKACTJOB SBS(ZENDPHP74)

For Zend Server version 9.1-2019:

WRKACTJOB SBS(ZENDPHP7)

For Zend Server 6-8.5:

WRKACTJOB SBS(ZENDSVR6)

For Zend Server 5:

WRKACTJOB SBS(ZENDSVR)

Verify these two jobs appear (use F5 to redisplay until they do):

ZSMONMNG     QTMHHTTP    BCI      .0  PGM-watchdog   
ZSMONMNG     QTMHHTTP    BCI      .0  PGM-MonitorNod

Step 3: Verify the monitor file now exists. 


For Zend Server version 2020:

/usr/local/zendphp74/var/db/monitor.db

For Zend Server version 9.1-2019:

/usr/local/zendphp7/var/db/monitor.db

For Zend Server version 6-8.5:

/usr/local/zendsvr6/var/db/monitor.db

For Zend Server version 5:

/usr/local/zendsvr/var/db/monitor

Step 4: Restart PHP.

In the Zend Server User Interface in your browser, use the 'Restart' button that appears in the upper right corner of most displays (bottom right for Zend Server 5).

After PHP restarts, there may not be any events to display. New events will begin to accumulate as they occur.