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.
This tool provides a means of quickly understanding when IBM i supplied database objects are missing.
The tool validates SYSBAS or an iASP, depending upon the SETASPGRP choice for the job.
The output of the tool always goes to the joblog.
The QSQIBMCHK tool reports the status of database objects but takes no action for recovery.
The QSQSYSIBM does the recovery.
Diagnosing The Problem
To invoke the object verification tool for SYSBAS:
CALL QSYS/QSQIBMCHK
To invoke the object verification tool for an iASP:
SETASPGRP ASPGRP(iASP-NAME)
CALL QSYS/QSQIBMCHK
Once the command runs and the tool is issued and completed, the joblog contains information that identifies if there are missing 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>
CHGSYSLIBL LIB(QSYS2#####) <- ##### is the iASP number.
CHGSYSLIBL LIB(QSYS#####) <- ##### 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:
30 October 2020
UID
nas8N1018936