XMPACCOX REXX to call DSNACCOX - updated for Db2 12?

Chris Louden

XMPACCOX REXX to call DSNACCOX - updated for Db2 12?

Hi everyone,

Our shop has been using the XMPACCOX REXX script to call DSNACCOX for Db2 on Z maintenance recommendations for a few years now. Link here: https://ruban.de/db2zos/rexx-procedure-to-execute-dsnaccox-db2-supplied-stored-procedure-v10/

It hasn't been updated since Db2 10, and now there are new output parameters in the DSNACCOX stored procedure that are returned after moving to Db2 12 M500+ and they seem to break this script. Before we get too involved in hacking this code to get it working correctly, I was just wondering if anyone else was using this REXX and had already modified for Db2 12? 

don isenstadt

XMPACCOX REXX to call DSNACCOX - updated for Db2 12?
(in response to Chris Louden)
Yes! We ran into the exact same issue.

You will have to add:
":RRIPEMPTYLIMIT :RRIPEMPTYLIMIT_IND ,",
":RRTHASHOVRFLWRATPCT :RRTHASHOVRFLWRATPCT_IND,",
":RRTPBGSPACEPCT :RRTPBGSPACEPCT_IND ";
Into the sqlstmt = "FETCH C102 INTO ", statement
You will get and SQL -104 if they are not there ...
Also you might see sql -305s in query monitor with the use of this routine .. they are working on a fix for that. The error
Does not cause any issues with the performance of the routine.

-don


Get Outlook for iOS https://aka.ms/o0ukef
________________________________
From: Chris Louden <[login to unmask email]>
Sent: Monday, May 18, 2020 7:25:23 AM
To: [login to unmask email] <[login to unmask email]>
Subject: [EXT] [DB2-L] - XMPACCOX REXX to call DSNACCOX - updated for Db2 12?


Hi everyone,

Our shop has been using the XMPACCOX REXX script to call DSNACCOX for Db2 on Z maintenance recommendations for a few years now. Link here: https://ruban.de/db2zos/rexx-procedure-to-execute-dsnaccox-db2-supplied-stored-procedure-v10/ https://urldefense.proofpoint.com/v2/url?u=https-3A__ruban.de_db2zos_rexx-2Dprocedure-2Dto-2Dexecute-2Ddsnaccox-2Ddb2-2Dsupplied-2Dstored-2Dprocedure-2Dv10_&d=DwMFaQ&c=zQLjxGaFENyz7VqOLRV_eQ&r=YYJeIjQmwOPmpdSI5kr3va7kMQC7npk_rze_KSpW0lE&m=jtB9yDKnY-pAXgND54rFju19IhKQVtukD95HFISOij8&s=fJaXa6d6si5gGdaBocc2RCmiOBDsz0loU02L2bERqmI&e=

It hasn't been updated since Db2 10, and now there are new output parameters in the DSNACCOX stored procedure that are returned after moving to Db2 12 M500+ and they seem to break this script. Before we get too involved in hacking this code to get it working correctly, I was just wondering if anyone else was using this REXX and had already modified for Db2 12?

-----End Original Message-----

Chris Louden

RE: XMPACCOX REXX to call DSNACCOX - updated for Db2 12?
(in response to don isenstadt)

Worked like a champ. Thanks Don. 

don isenstadt

XMPACCOX REXX to call DSNACCOX - updated for Db2 12?
(in response to Chris Louden)
Chris,

That’s great. Keep your eye out for this apar to close.
From our ticket with IBM…
APAR PH25108 Target date is 12/31.


From: Chris Louden <[login to unmask email]>
Sent: Monday, May 18, 2020 11:35 AM
To: [login to unmask email]
Subject: [EXT] [DB2-L] - RE: XMPACCOX REXX to call DSNACCOX - updated for Db2 12?


Worked like a champ. Thanks Don.

-----End Original Message-----

Alan Gredell

RE: XMPACCOX REXX to call DSNACCOX - updated for Db2 12?
(in response to don isenstadt)

Hi, Folks,

If you don't mind, can you tell me where you find this REXX routine? IBM-Supplied, I thought?  Thanks!

don isenstadt

XMPACCOX REXX to call DSNACCOX - updated for Db2 12?
(in response to Alan Gredell)
You might look here:
https://ruban.de/db2zos/rexx-procedure-to-execute-dsnaccox-db2-supplied-stored-procedure-v10/

From: Alan Gredell <[login to unmask email]>
Sent: Tuesday, May 19, 2020 9:19 AM
To: [login to unmask email]
Subject: [EXT] [DB2-L] - RE: XMPACCOX REXX to call DSNACCOX - updated for Db2 12?


Hi, Folks,

If you don't mind, can you tell me where you find this REXX routine? IBM-Supplied, I thought? Thanks!

-----End Original Message-----

Michael Hannan

RE: XMPACCOX REXX to call DSNACCOX - updated for Db2 12?
(in response to don isenstadt)

Is that different to what the original question says no longer works?

Michael Hannan,
DB2 Application Performance Specialist