A fix is available
APAR status
Closed as new function.
Error description
TEMPLATE UTILITY ENHANCEMENT TO SUPPORT LOAD UTILITY TO LOAD FROM AN HSF FILE.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS * * users of the LOAD or UNLOAD utilities who * * want to READ or WRITE to a z/OS UNIX file. * **************************************************************** * PROBLEM DESCRIPTION: An Enhancement to the TEMPLATE control * * statement to dynamically allocate a * * z/OS UNIX file (HFS) for the LOAD and * * UNLOAD utilities. * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available. * **************************************************************** An Enhancement to the TEMPLATE control statement to dynamically allocate a z/OS UNIX file (HFS) for the LOAD and UNLOAD utilities.
Problem conclusion
Temporary fix
Comments
Code is changed to support UNIX files as an input for the LOAD utility or as an output for the UNLOAD utility, implemented with the new PATH keyword for the TEMPLATE statement. However, in order to use the TEMPLATE PATH FILEDATA RECORD syntax, the fixes for the following z/OS APARs must be installed: OA25204, OA25206, and OA25280 If the fix for PK70269 is installed and z/OS does not have the above APARs or the z/OS is lower than release 1.8, the utility will fail with return code 8 and IDCAMS messages are issued. For example, trying to open with FILEDATA RECORD without the above APARs installed will receive a failure similar to the following error: DSNU1042I 259 08:41:26.20 DSNUGDYN - START OF IDCAMS MESSAGES IKJ56893I PATH /u/admf001/test1 NOT ALLOCATED+ IGD17501I ATTEMPT TO OPEN A HFS FILE FAILED, RETURN CODE IS (0000006F) REASON CODE IS (EF086015) FILENAME IS (/u/admf001/test1) DSNU1043I 259 08:41:26.20 DSNUGDYN - END OF IDCAMS MESSAGES DSNU012I 259 08:41:26.22 DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8 ============================================================= The Utility Guide and Reference is updated with the following changes: The TEMPLATE control statement will have new keywords, and the description of LRECL and RECFM are changed. The user can specify either TEMPLATE with DSN or PATH, but not both. >>TEMPLATE--template_name--- -DSN--name_expression- ----<< |-path_expression------| path_expression: -FILEDATA RECORD-----RECFM VB---LRECL 32756- >>PATH-pathname-|--------------------------------------------|<< | | |-FILEDATA- -TEXT--- -RECFM- -VB- -LRECL int-| |-BINARY-| |-V--| |-RECORD-| |-FB-| |-F--| >> ------------------------------------------------------- - << | ---,--------- ---,------- | | | -ORDONLY*-- | | -SIRUSR- | | |-PATHOPTS(v|-OCREAT**--||-)-PATHMODE-(-v|-SIWUSR-|-|-)-| |-OWRONLY**-| |-SIXUSR-| |-ONONBLOCK-| |-SIRWXU-| |-SIRGRP-| |-SIWGRP-| |-SIXGRP-| |-SIRWXG-| |-SIROTH-| |-SIWOTH-| |-SIXOTH-| |-SIRWXO-| >>- ---------------------------------------- -----------------<< | -KEEP--- -KEEP--- | |-PATHDISP-(-|--------|-,-|--------|-)---| |-DELETE-| |-DELETE-| Note: * For LOAD the default is ORDONLY ** For UNLOAD the default is (OCREATE,OWRONLY) PATH Specifies a z/OS UNIX file path name which can be a USS pipe path name. The path name must be in single byte EBCDIC, and can not exceed a length of 255 bytes. If it contains blanks, it must be enclosed by single quotes. PATH does not support name substitution variables. Restriction: When using TEMPLATE with the PATH keyword, the utility can not tell the difference between a physical file or a pipe. Therefore, the utility will be blocked from restarting and the LOAD DISCARDDN keyword is not supported. PATH can only be used for input/output for LOAD (INDDN) and UNLOAD (UNLDDN) utility. LRECL Specifies the record length of the MVS BATCHPIPES SUBSYSTEM file or z/OS UNIX file. This option is required when SUBSYS or PATH is specified. However, when TEMPLATE PATH is specified, FILEDATA RECORD is the default, and when FILEDATA RECORD is specified, LRECL defaults to 32756. RECFM Specifies the record format of the MVS BATCHPIPES SUBSYSTEM file or z/OS UNIX file. The valid values are F, FB, V, or VB. This option is required when SUBSYS or PATH is specified. However, when TEMPLATE PATH is specified, FILEDATA RECORD is the default, and when FILEDATA RECORD is specified, RECFM defaults to VB. FILEDATA is an optional keyword to describes the content type of a z/OS UNIX file. The valid values are TEXT, BINARY, and RECORD. The default value is RECORD. PATHOPTS is an optional keyword to specify the access and status for the z/OS UNIX file named in the PATH parameter. The valid values are: ORDONLY Specifies that the utility should open the file for read access only. OCREAT Specifies that: -If the file does not exist, the system is to create it If a directory specified in the pathname does not exist, one is not created, and the new file is not created. -If the file already exists, the system allows the utility to use the existing file. OWRONLY Specifies that the utility should open the file for write access only. ONONBLOCK Specifies the following, depending on the type of file: -For a FIFO special file, such as a USS pipe file: o With ONONBLOCK specified and ORDONLY access: An open() function for reading-only returns without delay. o With ONONBLOCK not specified and ORDONLY access: An open() function for reading-only blocks (waits) until a process opens the file for writing. o With ONONBLOCK specified and OWRONLY access: An open() function for writing-only returns an error if no process currently has the file open for reading. o With ONONBLOCK not specified and OWRONLY access: An open() function for writing-only blocks (waits) until a process opens the file for reading. -For a character special file that supports nonblocking open: o If ONONBLOCK is specified: An open() function returns without blocking (waiting) until the device is ready or available. Device response depends on the type of device. o If ONONBLOCK is not specified: An open() function blocks (waits) until the device is ready or available Specification of ONONBLOCK has no effect on other file types. Please refer to MVS JCL Reference for more information on these options. The default for LOAD is ORDONLY. The default for UNLOAD is OCREAT and OWRONLY. PATHMODE is an optional keyword to specify the filemode of the HFS file. The valid values are: -SIRUSR Specifies permission for the file owner to read the file. -SIWUSR Specifies permission for the file owner to write the file. -SIXUSR Specifies permission for the file owner either: o To search, if the file is a directory o To execute the program in the file, for a file other than a directory -SIRWXU Specifies permission for the file owner either: o To read, write, and search, if the file is a directory o To read, write, and execute, for a file other than a directory This value has the same effect as specifying all three parameters (SIRUSR, SIWUSR, and SIXUSR). -SIRGRP Specifies permission for users in the file group class to read the file. -SIWGRP Specifies permission for users in the file group class to write the file. -SIXGRP Specifies permission for users in the file group class either: o To search, if the file is a directory o To execute the program in the file, for a file other than a directory -SIRWXG Specifies permission for users in the file group class either: o To read, write, and search, if the file is a directory o To read, write, and execute, for a file other than a directory This value has the same effect as specifying all three parameters (SIRGRP, SIWGRP, and SIXGRP). -SIROTH Specifies permission for users in the file other class to read the file. -SIWOTH Specifies permission for users in the file other class to write the file. -SIXOTH Specifies permission for users in the file other class either: o To search, if the file is a directory o To execute the program in the file, for a file other than a directory -SIRWXO Specifies permission for users in the file other class either: o To read, write, and search, if the file is a directory o To read, write, and execute, for a file other than a directory This value has the same effect as specifying all three parameters (SIROTH, SIWOTH, and SIXOTH). Please refer to MVS JCL Reference for more information on these options. The default value is SIRUSR. FILEDISP is an optional keyword to specify the disposition of a z/OS UNIX file when the job step ends normally or abnormally. The valid values are KEEP or DELETE. The MVS system default is KEEP,KEEP. Messages and Codes manual needs to be changed, message DSNU1051I and DSNU1052I is changed: |DSNU1051I csect-name TEMPLATE SUBSYS or PATH IS NOT SUPPORTED TO ALLOCATE FILE FOR util-name UTILITY. |Explanation: Dynamically allocating a BatchPipes or z/OS UNIX file is not supported for 'util-name' UTILITY. Severity: 8 (error) User Response: In the TEMPLATE utility control statement, | remove the SUBSYS keyword or the PATH keyword, and | resubmit the job. DSNU1052I csect-name util-name UTILITY DOES NOT SUPPORT | RESTART WHEN TEMPLATE SUBSYS or PATH IS USED. |Explanation: The utility that uses the BatchPipes or z/OS UNIX file cannot be restarted. Severity: 8 (error) User Response: Use the DB2 command TERM UTILITY to terminate the stopped utility, and then rerun the job.
APAR Information
APAR number
PK70269
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
2008-08-07
Closed date
2009-02-11
Last modified date
2009-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK43947 UK43948
Modules/Macros
DSNDUDS DSNDUSMR DSNFMDIR DSNFUDRD DSNUFCMR DSNUGDDR DSNUGDYN DSNUGMST DSNUGPPR DSNUGPRT DSNUGPRV DSNUGPS2 DSNUGQSV DSNUGSDA DSNUGTDS DSNUGTTR DSNUMSGD DSNUULGL
| GC18960203 | SC18742706 | GC18984902 | SC18985502 |
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:
02 April 2009