A fix is available
APAR status
Closed as new function.
Error description
DB2 FOR Z/OS ADMINISTRATIVE ENABLEMENT STORED PROCEDURES
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 UDB for z/OS Version 8 and * * users of DB2 Version 9.1 for z/OS who would * * like to use DB2-supplied stored procedures * * for job management, data set management, * * parallel utility execution, system * * information retrieval, and command * * execution. * **************************************************************** * PROBLEM DESCRIPTION: This PTF adds stored procedures for DB2 * * for z/OS administrative enablement to * * the DB2 for z/OS Version 8 and DB2 * * Version 9.1 for z/OS base FMIDs, * * HDB8810 and HDB9910. They are enhanced * * replacements for a subset of stored * * procedures currently provided by the * * z/OS Enablement feature (FMIDs * * JDB881D and JDB991D), which is * * being deprecated. * **************************************************************** * RECOMMENDATION: Apply PTF * **************************************************************** The following stored procedures, which are currently shipped with FMIDs JDB881D and JDB991D, are added to FMID HDB8810 and HDB9910 and renamed as follows: Old New Procedure Procedure Procedure Name Name Description --------- ------------------ -------------------------------- DSNACCUC ADMIN_COMMAND_UNIX Issue z/OS UNIX command DSNACCTS ADMIN_COMMAND_DSN Issue DSN subcommand DSNACCJS ADMIN_JOB_SUBMIT Submit a job DSNACCJF ADMIN_JOB_FETCH Fetch the output of a job DSNACCJQ ADMIN_JOB_QUERY Query the status and completion information of a job DSNACCJP ADMIN_JOB_CANCEL Purge or cancel a job DSNACCDF ADMIN_DS_BROWSE Browse a data set, GDS or library member (only data sets with LRECL=80 and RECFM=FB are supported) DSNACCDS ADMIN_DS_WRITE Create, append or replace a data set, library member, or GDS (only data sets with LRECL=80 and RECFM=FB are supported) DSNACCDL ADMIN_DS_LIST List cataloged data sets, libraries or GDG, library members, or GDS in a GDG DSNACCDR ADMIN_DS_RENAME Rename a data set, library, or library member DSNACCDD ADMIN_DS_DELETE Delete a data set, library, GDS, or library member DSNACCDE ADMIN_DS_SEARCH Check the existence of a data set, library, GDG, GDS, or library member DSNACCSS ADMIN_INFO_HOST Get host name of a DB2 subsystem or host name of every data sharing group member DSNACCMO ADMIN_UTL_SCHEDULE Execute parallel utility execution DSNACCST ADMIN_UTL_SORT Sort objects for parallel utility execution These stored procedures are defined in schema SYSPROC. This APAR also changed the DB2_CMD parameter of the stored procedure SYSPROC.ADMIN_COMMAND_DB2 from VARCHAR(32700) to VARCHAR(32704) in Version 9 for consistency with the other administrative enablement stored procedures.
Problem conclusion
Temporary fix
Comments
The following stored procedures which are currently shipped with FMIDs JDB881D and JDB991D are added to FMID HDB8810 and HDB9910. These stored procedures are renamed as follows: Old New Procedure Procedure Procedure Name Name Description --------- ----------------- -------------------------------- DSNACCUC ADMIN_COMMAND_UNIX Issue z/OS UNIX command DSNACCTS ADMIN_COMMAND_DSN Issue DSN subcommand DSNACCJS ADMIN_JOB_SUBMIT Submit a job DSNACCJF ADMIN_JOB_FETCH Fetch the output of a job DSNACCJQ ADMIN_JOB_QUERY Query the status and completion information of a job DSNACCJP ADMIN_JOB_CANCEL Purge or cancel a job DSNACCDF ADMIN_DS_BROWSE Browse a data set, GDS or library member (only data sets with LRECL=80 and RECFM=FB are supported) DSNACCDS ADMIN_DS_WRITE Create, append or replace a data set, library member, or GDS (only data sets with LRECL=80 and RECFM=FB are supported) DSNACCDL ADMIN_DS_LIST List cataloged data sets, libraries or GDG, library members, or GDS in a GDG DSNACCDR ADMIN_DS_RENAME Rename a data set, library, or library member DSNACCDD ADMIN_DS_DELETE Delete a data set, library, GDS, or library member DSNACCDE ADMIN_DS_SEARCH Check the existence of a data set, library, GDG, GDS, or library member DSNACCSS ADMIN_INFO_HOST Get host name of a DB2 subsystem or host name of every data sharing group member DSNACCMO ADMIN_UTL_SCHEDULE Execute parallel utility execution DSNACCST ADMIN_UTL_SORT Sort objects for parallel utility execution Aside from renaming the stored procedure names, the following major changes and enhancements were also made to these stored procedures: o Parameter convergence (name, type, length, sequence) o Result set convergence (name, length) o Return code convergence (0 - normal, 4 - warning, 8 - error, 12 - severe error) o Returning complete and informative messages o Removal of 'unused' or 'unnecessary' parameters o ADMIN_JOB_CANCEL is enhanced to invoke the IEFSSREQ service with function code 2 to purge or cancel a job instead of issuing the JES2 command $C or the JES3 command $F via the extended MCS console. This change enables one to restrict the authority to cancel or purge a job. o ADMIN_JOB_QUERY is enhanced to return job completion information, such as job completion code, job completion type, system and user abend code. o ADMIN_UTL_SCHEDULE is enhanced to: - Call DSNUTILU, instead of DSNUTILS - Return a new result set SYSIBM.UTILITY_RETCODE to return the DSNUTILU return code for each DSNUTILU invocation - Replace &OBJECT. with QUALIFIER.NAME ž**** PE08/02/11 PTF IN ERROR. SEE APAR PK60366 FOR DESCRIPTION
APAR Information
APAR number
PK45599
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-05-21
Closed date
2007-12-07
Last modified date
2008-02-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK32059 UK32060
Modules/Macros
DSN@DMCD DSN@DMCU DSN@DMDB DSN@DMDL DSN@DMDW DSN@DMIH DSN@DMJF DSN@DMJS DSN@DMUM DSN@DMUS DSNADMAL DSNADMAT DSNADMCD DSNADMCS DSNADMCU DSNADMDB DSNADMDC DSNADMDD DSNADMDE DSNADMDL DSNADMDM DSNADMDR DSNADMDW DSNADMH1 DSNADMID DSNADMIH DSNADMIO DSNADMJF DSNADMJP DSNADMJQ DSNADMJS DSNADMJ5 DSNADMJ6 DSNADMMC DSNADMMG DSNADMMW DSNADMRE DSNADMSH DSNADMUM DSNADMUS DSNCIM DSNCIMX DSNTIJRA DSNTIJSG DSNTINS1 HDB8810J HDB9910J
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
29 February 2008