RC/Query HDDL command gets an OSF error message online and an abend S378-14 in batch
Article ID: 379371
Updated On:
Products
Issue/Introduction
The HDDL command in the RC/Query menu, executed in a batch job to list a set of Db2 objects with a lot Views defined, got an abend S378-04 with the following error messages.
PXM0810 XMANAGER RECOVERY IN PROGRESS (TCB 009B6B88)
PXM0811 PSW: 070C1400 8151C500 LMOD: *UNKNOWN OFFSET: N/A ABEND: S378
...
IEA705I ERROR DURING FREEMAIN SYS CODE = 378-14 JHDDLPLT HDDLSTEP 40
PXMxxxx messages are from Xmanager started task but nothing was reported in the Xmanager output.
When the HDDL command was executed in the ISPF online panels got an OFS internal error message.
RC=012, RCODE=0012 OFS Internal error
Resolution
The problem was caused by the storage allocation. The HDDL command executed in the batch job had a REGION=0M parameter but without a MEMLIMIT parameter, this caused problems in the storage allocation when there were a large number of Views to be listed in the generated DDL output.
The solution was to run the HDDL batch job with REGION=0M,MEMLIMIT=32G parameters. However it was not possible to increase the TSO/ISPF region with the right MEMLIMIT parameter, so there was not any solution for the online HDDL execution.
When there is a large number of Views to be listed in the generated DDL output then the HDDL command has to be executed in a batch job with REGION=0M,MEMLIMIT=nnG parameters. The MEMLIMIT=nnG parameter has to be adjusted depending on the number of Views but it cannot be MEMLIMIT=NOLIMT, sometimes this is the default value when in the JCL there is REGION=0M.
Feedback
