A fix is available
APAR status
Closed as program error.
Error description
(HPU 5.1 only) After the fix for PH06254 has been applied, any unload, including the INZCHECK customization job, run on against a given Db2 subsystem or a data sharing group fails after having issued the following messages: INZU220E THE SETTINGS FOR ssid IN THE PARMLIB ARE INCOMPLETE ... INZU366I UTILITY RETURN CODE 12 (REASON CODE 0x107b002) This occurs if the INZCHECK customization member is run after the following operation: - a new Db2 has been associated to the Db2 HPU settings - the discover utility has been run In such a case, the INZUTIL member from the parmlib contains a line as follows [ ssid ] where the ssid or Db2 group attach name affected by the issue is unduly surrounded by blanks. PB56006
Local fix
submit the INZTVAR customization job.
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Db2 High Performance Unload * **************************************************************** * PROBLEM DESCRIPTION: * * PH08138: * * An ABENDS0C4 intermittently occurs and the symptom dump * * shows a line formatted as follows: DATA * * AT PSW adr - xxxxxxxx xxxxE3x0 D080xxxx where x stands for * * un predictable/variable characters. * * Internal details * * The only necessary condition is to get one thread which is * * terminated. * * The end of one thread can be identified by the messages : * * INZU222I ddname , TOTAL NUMBER OF RECORDS WRITTEN number * * INZX009 tsname [PARTITION NO. p] READ, number ROWS PROCESSED * * * * PH08282: * * An ABENDS0C4 occurs with the following traceback in CEEDUMP * * data set: * * 6 ocharAppendChar * * +00000080 1893 IN * * 7 _inzplibPrintParmlib * * +000001B8 11920 IN * * 8 inzplibDisplayParameters * * * * This occurs whenever the following conditions are * * fullfilled: * * - Db2 HPU is run against an subsystem or a group attach * * which identifier (ssid or group attach * * name) is less than 4 characters longs * * - the display of the parmlib parameters (feature enabled * * through the DISPLAY_PARMLIB option * * from the Technical Parameters Options Block oand the * * VUU083/DISPPARM parmlib parameter) is to be * * performed. * * * * PH08552: * * Unlike prior versions, Db2 HPU 5.1 uses ACCESS REGISTERS to * * store data. * * If an external routine, e.g. an SMS one called during the * * Db2 HPU process, uses ACCESS REGISTERS * * without restoring them before exiting, HPU terminates with * * an ABENDU1234. Db2 HPU should be made * * robust to the impact of such an incorrect handling of ACCESS * * REGISTERS by external routines. * * * * PH08630: * * An unload run in native mode ends with completion code 8 * * after having issued a message reporting * * a CCSID conversion failure such as: * * INZI009E CUNLCNV ERROR : RC rc, REASON reason * * CONVERSION BETWEEN CCSID 37 AND CCSID dbcs-ccsid * * where dbcs-ccsid is the Db2 subsystem DBCS CCSID. * * This occurs when : * * - the table to unload has versions. * * - the table is encoded in EBCDIC or ASCII. * * - the Db2 subsystem/data sharing group is mixed. * * - the conversion services are available * * - the conversion of the blank encoded in CCSID 37 (0x40) * * into the DBCS CCSID of the table space * * to unload is not allowed by the IBM CUNLCNV converter. * * - the "Unicode Conversion Services substitution character * * mode (VZM008/SCUNSUB)" parameter is * * set to NO * * * * PH08791: * * After the fix for PH06254 has been applied, any unload, * * including the INZCHECK customization * * job, run against a given Db2 subsystem or a data sharing * * group fails after having issued the * * following messages * * INZU220E THE SETTINGS FOR ssid IN THE PARMLIB ARE * * INCOMPLETE OR ARE MISSING * * INZU366I UTILITY RETURN CODE 12 (REASON CODE 0x107b002) * * * * This occurs if the INZCHECK customization member is run * * after the following operation: * * - a new Db2 has been associated to the Db2 HPU settings * * - the discover utility has been run * * In such a case, the INZUTIL meber from the parmlib contains * * a line as follows * * [ ssid ] * * where the ssid or Db2 group attach name affected by the * * issue is unduly surrounded by blanks. * * * * PH09202: * * Fix 1 - A logical unload with the OPTIMIZE_PART_RANGE * * enabled and applicable (unload run in * * native mode against a partitioned table space) fails * * reporting DSNT408I SQLCODE = -204, ERROR: * * value_of_EXPLNUSR.table_name IS AN UNDEFINED NAME or unload * * the data from an irrelevant table * * with a creator name corresponding to the value set for the * * VUM035/EXPLNUSER parmlib parameter. * * This occurs if the following conditions are fullfilled. * * - the FROM clause of the logical unload specifes unqualified * * table names * * - the userid that submits the unload job is not the same as * * the one specified by * * VUM035/EXPLNUSER parmlib parameter and VUM035/EXPLNUSER is * * not set to CURRENT USER * * * * Fix 2 - The INZX090 messages issued to the console about an * * unload run in SQL mode unduly * * specifies a table space name. * * This occurs if the UNLOAD statement involves one unload run * * in native mode and one unload run in * * SQL mode. * * * * Fix 3 - The information about a table space to unload misses * * from the $PABF trace dataset. This * * occurs when the table space is defined trough a LISTDEF * * statement. When a LISTDEF statement * * defines more than one table space, the $PABF data set * * contains information about only one of * * these table spaces. * * * * Fix 4 - When the progress messages are requested to be * * issued with the DELTA mode through the * * PROGRESS_MSG_FREQ(n,DELTA) option or the setting of * * VUU050/ULFRQMSG parmlib parameter to * * n,DELTA, the first INZX089 message is issued one record too * * early, i.e. when n-1 records have * * been unloaded where the first message should be issued when * * the n th record have been unloaded. * * * * Fix 5 - An ABENDS0C4 occurs during the unload when both * * following conditons are fullfilled: * * - IFERROR DEFAULT is specified in OPTIONS * * REFORMAT * * - a DD statement with the $PABF ddname is * * specified. * * * * Fix 6 - An unload fails after having issued messages such as * * the following one: * * INZU220E THE SETTINGS FOR ssid IN THE PARMLIB ARE INCOMPLETE * * OR ARE MISSING * * INZU366I UTILITY RETURN CODE 12 (REASON CODE 0x107b002) * * This occurs when: * * - the ssid of the Db2 is less than 4 character long * * - the INZTVAR customization job is submitted after the * * INZCHECK customization job has been run. * * In such a case, the INZTVAR job generates the following * * wrong section name with an extra D * * preceeding the affected ssid. If the ssid is SSS, the * * INZUTIL member contains * * [DSSS] * * INCLUDE INZDSSS * * instead of the correct * * [SSS] * * INCLUDE INZDSSS * * * * PH09203: * * The CPU use dedicated to read the LDS of the table spaces * * when an unload is run in native mode * * may be offloaded to zIIP processor. * **************************************************************** * RECOMMENDATION: * * Apply the PTF for problem resolution * ****************************************************************
Problem conclusion
Code has been changed to fix this problem
Temporary fix
PH08138: None but as this is a rare and intermittent issue, a new run of the unload can be successful. PH08282: if displaying the parmlib parameters is not a requirement for subsequent processing, considered disabling this feature either at the Db2 HPU step level by specfying DISPLAY_PARMLIB NO or at the Db2 HPU level by setting VUU083/DISPPARM to NO. PH08552: None unless the external routine that does not restore the ACCES REGISTERS after use can be dertmined and fixed. PH08630: Run the unload in SQL mode by specifying the DB2 FORCE option. PH08791: Submit the INZTVAR customization job. PH09202: Fix 1 - None but you may consider qualifying the table name in the FROM clause to get the expected result Fix 5 - Unless $PABF DD statement is required for diagnosis purpose, remove the card. Fix 6 - Correct the wrong section title for the concerned ssid by removing the extra letter D from the section name.
Comments
×**** PE20/02/28 FIX IN ERROR. SEE APAR PH15696 FOR DESCRIPTION ×**** PE20/04/22 PTF IN ERROR. SEE APAR PH15431 FOR DESCRIPTION
APAR Information
APAR number
PH08791
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
510
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-02-20
Closed date
2019-03-11
Last modified date
2020-04-22
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI61772
Modules/Macros
INZUTILK INZTSSID
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R510 PSY UI61772
UP19/03/13 P F903
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0"}]
Document Information
Modified date:
30 March 2021