Page History

...

Environment

Zend Server for IBM i 9.1Zend Server 2020.x or higher running on any supported version of IBM i.  

Resolution

Here are two free SQLite editors that can be used with the Zend Server databases.  The first runs on your Windows PC, and can be used if you have a network drive set up to access your IBM i.  The second can be used from a web browser.

It is possible to make changes to your database tables that will make them unusable, forcing a recreate of the database or even possibly a clean install of 
Zend Server.  
Please use caution and common sense when using these tools.  Also, please make a copy of any .db file for backup before making any changes 
to it.  It is best to make the 
changes while the Zend Server jobs are not running.

...

To install this in Windows, just download and run the .exe file.  To open a database, navigate to the /usr/local/zendphp7zendphp74/var/db directory and choose one of the files with a .db extension.   Before making any changes to any of these files, make a back up copy.

...

$directory = '/usr/local/zendphp7zendphp74/var/db';

Save your changes, then upload the phpLiteAdmin.php file (and the configuration file if you used it) to your web site.  You can then run the phpLiteAdmin.php script on your website to work with the Zend Server databases. Remember to back up any database files before making any changes.

This utility offers very basic password protection.  It is a good idea to only have this script on your website when you are actually using it.  You can remove it 
when you don't need it, and quickly post it back up to the site the next time you need to use it.

...