A fix is available
APAR status
Closed as program error.
Error description
The recovery job with “Using RECOVER to IC and redo SQL” fails with: 'DSNT408I SQLCODE = -311, ERROR: THE LENGTH OF INPUT HOST VARIABLE NUMBER 7 IS NEGATIVE'. 'OR GREATER THAN THE MAXIMUM'. 'DSNT418I SQLSTATE = 22501 SQLSTATE RETURN CODE'.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 Recovery Expert z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The recovery job with Using RECOVER * * to IC and redo SQL fails with: * * 'DSNT408I SQLCODE = -311, ERROR: THE * * LENGTH OF INPUT HOST VARIABLE NUMBER 7 * * IS NEGATIVE'. * * 'OR GREATER THAN THE MAXIMUM'. * * 'DSNT418I SQLSTATE = 22501 SQLSTATE * * RETURN CODE'. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI82047
Reported component name
DB2 REC EXPERT
Reported component ID
5697H7400
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-05-23
Closed date
2017-08-16
Last modified date
2017-09-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI49596
Modules/Macros
ARY$MREP ARY#CMET ARY#DSA ARY#HSA ARY#TRS ARY@FD28 ARY@FFN8 ARY@FSP ARY@MNT ARYAC ARYAFER ARYAFPS ARYAFVL ARYAFWC ARYAFWR ARYALOG ARYA00 ARYA01 ARYA02 ARYA03 ARYA04 ARYA05 ARYA06 ARYA07 ARYA08 ARYA09 ARYA10 ARYA11 ARYA12 ARYA13 ARYA14 ARYA15 ARYA16 ARYA17 ARYA18 ARYA19 ARYA20 ARYA21 ARYA22 ARYA23 ARYA30 ARYA31 ARYA32 ARYA33 ARYA34 ARYA35 ARYA36 ARYA40 ARYA41 ARYA42 ARYA43 ARYA44 ARYA45 ARYA46 ARYA47 ARYA48 ARYA49 ARYA50 ARYA51 ARYA52 ARYA53 ARYA54 ARYA55 ARYA56 ARYA57 ARYA58 ARYA59 ARYA60 ARYA61 ARYA62 ARYA63 ARYA64 ARYA65 ARYA66 ARYA67 ARYA68 ARYA70 ARYA71 ARYBDCT ARYBHDR ARYBLNKT ARYBPC ARYBSDM ARYBSDR ARYBSDS ARYBSQL ARYCAF ARYCATF ARYCATR ARYCDC ARYCDICT ARYCFG ARYCFGRP ARYCFREP ARYCFRR ARYCMDR ARYCREP ARYCRRF ARYCSQL ARYCTAU ARYCUOW ARYCUOW6 ARYCURR ARYDB2S ARYDCNV ARYDCTP ARYDECP ARYDELER ARYDFLT ARYDSNM ARYDSPG ARYDSUM ARYDSUMR ARYDTLF ARYDTL1 ARYDTL2 ARYDTL3 ARYDTL4 ARYDTL6 ARYDTR ARYDTS ARYDYN ARYEDIT ARYERR ARYERRIN ARYETV ARYEXP ARYEXPI ARYEXTF ARYEXTFD ARYFA ARYFCP ARYFFV ARYFLD ARYFLDR ARYFRMTR ARYFR1F ARYFR1V ARYFR12 ARYFR2M ARYFR2V ARYFR6 ARYFR6A ARYFR6D ARYFR6I ARYFR6PR ARYFR6T ARYFR6TV ARYFR6X ARYFR64 ARYFTC ARYGAL ARYGEND ARYGENR ARYGEN1 ARYGFLT ARYGFL2 ARYGIC ARYGMR ARYGMT ARYGRWRT ARYHLI2 ARYHSM ARYIDCM ARYIDRP ARYIF ARYINB ARYINBR ARYINBX ARYINBXR ARYIN1 ARYIN1R ARYIN1X ARYIN1XR ARYIN4 ARYIN4R ARYIN4X ARYIN4XR ARYIOEX ARYIR2 ARYIXP ARYLBC1 ARYLBC2 ARYLBC3 ARYLB1 ARYLB2 ARYLB3 ARYLCC ARYLFP ARYLF1 ARYLF1A ARYLF1B ARYLF2 ARYLF3 ARYLF3W ARYLF4 ARYLLB ARYLOGP ARYLOGR ARYLPC ARYLPD ARYLVALT ARYLXP ARYMAINT ARYMDTL ARYMGR ARYMLS ARYMLSWR ARYMMIF ARYMPRT ARYMPR2 ARYMSP ARYM64PP ARYNBLKT ARYNNUMT ARYOBD ARYPEXP ARYPGR ARYPGR2 ARYPH ARYPRI ARYPSB ARYQT ARYQTL ARYQTP ARYRDR ARYREC ARYREC2 ARYREC3 ARYREC3W ARYRE64 ARYRM ARYRMW ARYRM64 ARYRRFC ARYRTT ARYRXML ARYSA ARYSBDB ARYSBDF ARYSI ARYSKLR ARYSKL2 ARYSLOG ARYSLX ARYSPLL ARYSQL ARYSQL0 ARYSQL0A ARYSQL0B ARYSQL1 ARYSQL1A ARYSQL1B ARYSQL1C ARYSQL2 ARYSQL2A ARYSQL2B ARYSQL9 ARYSQL9A ARYSQL9B ARYSQL9C ARYSQ1CA ARYSQ1CB ARYSQ9CA ARYSREP ARYSRPT ARYSTOR ARYSTYPE ARYSUBC ARYSUBG ARYTC ARYTV ARYTVF ARYTVRP ARYTZC ARYT00 ARYT01 ARYUDDF ARYUES ARYUEX ARYUNCRE ARYUNI ARYUNRE ARYURC ARYURID ARYURRE ARYVRD ARYWARN ARYWITF ARYWITF2 ARYWL1 ARYXDRP ARYXREP ARYXSLX ARYZSCHD ARYZSRB1 ARYZSRB2 ARY90 ARY91 ARY94 H30R320J
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI49596
UP17/08/26 P F708
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.
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCVQTW","label":"Db2 Recovery Expert"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 September 2017