Unlocking the Configure Database Module

Occasionally, the Maximo "configuring database" flag will get set (or remain set after a db edit), preventing any further database configuration. If you're sure that there's no changes pending, logon via SQL Query Analyzer as SYSADM and issue the following. Note that the "N" and "CONFIGURING" must be upper case.

                    USE database
                    UPDATE maxvars SET varvalue='N' WHERE varname='CONFIGURING'

Database Table Listing

Although you can view the database tables in the Database Configuraton Module, having a printed copy is very useful for marking up planned revisions. This SQR program will print the current tables listing.