PK70269: TEMPLATE UTILITY ENHANCEMENT TO SUPPORT LOAD FROM A Z/OS UNIX FILE

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
Publications Referenced
GC18960203 SC18742706 GC18984902 SC18985502  

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK43947

       UP09/03/18 P F903

  • R910 PSY UK43948

       UP09/03/18 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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

810

Reference #:

PK70269

Modified date:

2009-04-02

Translate my page

Machine Translation

Content navigation