Troubleshooting
Problem
This document discusses a tool for checking IBM-supplied database objects within QSYS2, SYSIBM, SYSIBMADM, SYSPROC, SYSTOOLS.
Symptom
Users encounter situations where QSYS2, SYSIBM, SYSIBMADM, SYSPROC, SYSTOOLS objects are missing.
The tool provides a means of quickly understanding when IBM i supplied database objects are missing.
Validates objects in SYSBAS or an iASP (depending upon the SETASPGRP choice for the job.)
The output of the tool always goes to the joblog.QSQSYSIBM CHECKONLY tool reports the status of database objects but takes no action for recovery.QSQSYSIBM does the recovery.
(7.3 SI75289, 7.4 SI75288, 7.5 base release - QSQSYSIBM CHECKONLY is preferred over QSQIBMCHK as it will check for the existence and version number of the object(s). )
- QSQIBMCHK can still be useful as it shows us where the object is missing.
Diagnosing The Problem
To invoke the object verification tool for SYSBAS:
SETASPGRP *NONECALL QSYS/QSQSYSIBM CHECKONLY
To invoke the object verification tool for an iASP:SETASPGRP ASPGRP(iASP-NAME)CALL QSYS/QSQSYSIBM CHECKONLY
Once the command completes, the joblog will contain information that identifies missing or back-leveled objects.
Resolving The Problem
To recreate IBM-supplied objects run the following commands.
These steps result in IBM-supplied objects being dropped and recreated which could cause disruption for active jobs that depend upon these objects.
You do not need to be restricted but you may want to wait for a lower usage time of day.
If objects are missing after taking corrective action, consult the joblog to understand why the object(s) failed to create.SETASPGRP <*NONE >CHGJOB CCSID(XX) <- Replace XX with the CCSID used by character columns using the DSPFFD command on QSYS/QADBXREF file.CALL QSYS/QSQSYSIBM
To re-create the objects in an iASP, you should do the following:
1. Set the ASP group using the SETASPGRP command, then CHGSYSLIBL before doing the call to QSQSYSIBM as follows:CHGJOB CCSID(XX) <- Replace XX with the CCSID used by character columns using the DSPFFD command on QSYS/QADBXREF file.SETASPGRP <iASP-NAME>ADDLIBLE LIB(QSYS2#####) <- ##### is the iASP number.CALL QSYS/QSQSYSIBM
2. After SETASPGRP, issue a WRKLIB QSYS* or QSYS2* to see the iASP.
Once the command runs and the tool is issued and completed, the joblog contains information that identifies if there are missing objects.
For further details, refer to APAR SE27600.
Historical Number
N1018936
N1015126
N1011140
Was this topic helpful?
Document Information
Modified date:
26 March 2026
UID
nas8N1018936