PK40400: THIS APAR IS CREATED TO PROVIDE NEW FUNCTION TO DB2 HPU R310, INCLUDING UNLOAD OF XML COLUMNS.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • This APAR is created to provide New Function to DB2 HPU R310.
    including unload of XML columns.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 High Performance Unload.        *
    ****************************************************************
    * PROBLEM DESCRIPTION: Support of XML columns using File       *
    *                      Reference or in stream. This support    *
    *                      is added in DB2 FORCE and in DB2 YES,   *
    *                      the SELECT is processed by DB2. PB 8726 *
    *                                                              *
    *                      Additional 310 Symptoms from PK38957... *
    *                                                              *
    *                      27. Unloading a partitioned table       *
    *                      space into a PDS file generating one    *
    *                      seperate member per partition should    *
    *                      not be accepted. This case was not      *
    *                      controled and the unloaded data was     *
    *                      not usable. A control is now done to    *
    *                      avoid this case and a new error         *
    *                      message INZU501E is issued. PB 8705     *
    *                      28. When a template that generates a    *
    *                      PDS file is used in DB2 FORCE, and      *
    *                      when the PDS already exists, HPU        *
    *                      complains that the DIR keyword is not   *
    *                      coded. For an existing PDS, the DIR     *
    *                      keyword sould be ignored and not        *
    *                      mandatory. The DISP should be set to    *
    *                      SHR when the PDS already exist. PB 8708 *
    *                      29. When a SUBSTR is used on a LOB      *
    *                      column and when the LOB is unloaded     *
    *                      using a FILE RERERENCE, an abend U1210  *
    *                      can occur. PB 8709                      *
    *                      30. An abend U1135 is issued when an    *
    *                      ORDER BY is requested on a LOB column   *
    *                      in a select processed natively. Such    *
    *                      operation is not supported. A new       *
    *                      error message INZU503E is now issued.   *
    *                      PB 8710                                 *
    *                      31. Error message INZU147E ERROR :      *
    *                      DUPLICATE COLUMN colname IN ORDER BY    *
    *                      CLAUSE  is issued for a SELECT          *
    *                      processed natively that unloads LOB     *
    *                      data and when some of the columns of    *
    *                      the ORDER BY clause are not part of     *
    *                      the selected items. PB 8711             *
    *                      32. In UNLOAD PLUS syntax or            *
    *                      FASTUNLOAD syntax, the output data is   *
    *                      incorrect for columns for which a       *
    *                      NULLIF (U+) or DEFAULTIF (FU) clause    *
    *                      is used, when the constant value is     *
    *                      shorter than the output field. PB 8721  *
    *                      33. En abend U1129 is issued when a     *
    *                      DATE column is unloaded into a CHAR     *
    *                      field smaller than the minimum length   *
    *                      (10 characters). The correct behaviour  *
    *                      is to truncate the date field on the    *
    *                      specified number of characters. PB 8723 *
    *                      34. FastUnload Syntax: A FLOAT column   *
    *                      unloaded in OUTPUT-FORMAT EXTERNAL      *
    *                      does not adhere to the SQL rules. The   *
    *                      mantissa contains 18 digits when the    *
    *                      SQL limit is 17 digits. PB 8725         *
    *                      36. Error message INZU025E INVALID      *
    *                      OPERAND FOR OPERATOR STRIP() is issued  *
    *                      when RTRIM or LTRIM scalar function is  *
    *                      used. PB 8727                           *
    *                      37. In FORMAT DELIMITED, the GRAPHIC    *
    *                      columns are unloaded in GRAPHIC format  *
    *                      instead of GRAPHIC EXTERNAL (the SO/SI  *
    *                      are missing). This is a regression      *
    *                      compared to pre-V8 support. PB 8733     *
    *                      38. In V8 NFM, in DB2 FORCE a SQLCODE   *
    *                      +354 on a multi-row fetch is ignored    *
    *                      and may lead to an abend S0C7 or        *
    *                      incorrect data in the output file.      *
    *                      PB 8738                                 *
    *                      39. Error message IKJ56246I DATA SET    *
    *                      dsname NOT ALLOCATED, FILE IN USE when  *
    *                      unloading in parallel 2 table spaces    *
    *                      that have the same PSID but a           *
    *                      different DBID. For one of the 2        *
    *                      tablespaces, the unloaded data is       *
    *                      incorrect because HPU reads from the    *
    *                      wrong LDS file. The result is           *
    *                      unpredictable. In addition, if the      *
    *                      tablespaces are partitioned, the        *
    *                      unload fails with an abend U1005.       *
    *                      PB 8739                                 *
    *                      40. When keyword OUTDDN is missing,     *
    *                      HPU should issue error message          *
    *                      INZU096E REQUIRED KEYWORD, OUTDDN, NOT  *
    *                      SPECIFIED, PROCESSING TERMINATED        *
    *                      Instead of that when the OUTDDN and     *
    *                      FORMAT keywords are both missing,       *
    *                      either message INZU097E SYNTAX ERROR -  *
    *                      UNRECOGNIZED ELEMENT   FOR SELECT       *
    *                      BLOCK or INZU039E FATAL SYNTAX ERROR    *
    *                      BEFORE LINE nn COLUMN nn are issued.    *
    *                      PB 8746                                 *
    *                      41. HPU 310 Only: When a semicolon was  *
    *                      missing between 2 UNLOAD commands, HPU  *
    *                      was not issuing any error message. This *
    *                      control has been reintroduced in the    *
    *                      HPU parser. The error message issued    *
    *                      is INZU015E UNLOAD TABLESPACE STATEMENT *
    *                      MUST BE TERMINATED BY A SEMI-COLON.     *
    *                      PB 8753                                 *
    *                      42. Requirement MR0212077834. External  *
    *                      sort for select processed by DB2.       *
    *                      PB 8574                                 *
    *                      43. An abend S0C4 occurs when DB2       *
    *                      FORCE is coded on a physical unload     *
    *                      (UNLDDN) for which no logical unload    *
    *                      (SELECT) is coded. PB 8758              *
    *                      44. Processing of HIDDEN columns:       *
    *                      A new option HIDDEN YES/NO has been     *
    *                      added to the OPTIONS block. A new       *
    *                      parameter can also be coded on the      *
    *                      EXEC card HIDDEN(YES/NO). PB 8764       *
    *                      45. Requirement MR0702012835. New       *
    *                      message is issued to signal that the    *
    *                      access mode of the unloaded object has  *
    *                      been changed. INZU508I TABLE            *
    *                      creator.name HAS BEEN LOCKED IN SHARE   *
    *                      MODE DURING UNLOAD PROCESS. PB 8767     *
    *                      46. Support of COMMON TABLE EXPRESSION  *
    *                      has been added. PB 8768                 *
    *                      47. The value of the ULDEGREE parmlib   *
    *                      variable is ignored. PB 8770            *
    *                      48. An abend S0C4 can occur when        *
    *                      unloading from an INLINE Image Copy     *
    *                      without specifying the INLINE keyword   *
    *                      or CHECK keyword in the SYSIN DD card.  *
    *                      HPU will now end with RC 8 and issue a  *
    *                      message to explain that the pages are   *
    *                      not in the expected sequence. PB 8775   *
    *                      49. When a LISTDEF includes a table     *
    *                      that has a CLONE, and when the LISTDEF  *
    *                      is used in 2 select from list to        *
    *                      unload the base table and the clone     *
    *                      using the CLONE keyword, the first      *
    *                      table requested is unloaded twice.      *
    *                      PB 8756                                 *
    *                      50. When a LISTDEF with CLONED YES is   *
    *                      coded, HPU terminates with error        *
    *                      message INZU039E FATAL SYNTAX ERROR     *
    *                      BEFORE LINE nn COLUMN nn. PB 8787       *
    *                      51. Procedure INZT02 doesn't free the   *
    *                      files allocated to write the generated  *
    *                      members. PB 8788                        *
    *                      52. Inconsistency between the           *
    *                      processing of the char and of the       *
    *                      data/time columns in FORMAT DELIMITED.  *
    *                      When no delimited is coded (DELIM       *
    *                      parameter is not specified in sysin),   *
    *                      the CHAR columns are not delimited. If  *
    *                      parmlib variable DTDELIM is set to YES, *
    *                      the date/time columns are delimited     *
    *                      using a blank character, which is not   *
    *                      consistent with the processing of the   *
    *                      CHAR columns. In addition if DELIM ''   *
    *                      is coded, a binary value is used as a   *
    *                      delimiter (x'04') In such a case        *
    *                      nodelimiter should be added to the      *
    *                      data. PB 8792                           *
    *                      53. ISPF INTERFACE: when the HPU        *
    *                      application is invoked using DB2 ADMIN, *
    *                      an ISPF error message can be issued:    *
    *                      ISPD014 Data set not cataloged 'IVAR'   *
    *                      was not found in catalog. PB 8795       *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Not a bug.
    
    Additional 310 fixes from PK38957...
    
    27. Modules inzpab and inzmsgswere changed to do this control
    and issue the new message.
    28. Modules otmplate and inzctrlh were changed to improve the
    processing for existing PDS files.
    29. Module inzgcxtr was changed to avoid this problem.
    30. Modules inzctrl and inzmsgs were changed to process
    correctly this case.
    31. Module inzpab was changed to fix this problem.
    32. Module inzctrlh was fixed to process correctly this.
    33. Module inzctrlh was changed to process correctly this
    truncation case.
    34. Modules udbcrfel and inzpab were changed to generate a
    value that follows the SQL rules.
    36. Module inznode was whanged to fix this problem.
    37. Modules inzctrlh inztoken inzmain inzrload were changed to
    use a new parmlib parameter ULOPTNS/DELIMITEDGRAPHEXT in order
    to determine of the GRAPHIC should be unloaded as GRAPHIC or
    GRAPHIC EXTERNAL in FORMAT DELIMITED.
    38. Module inzcrxsm was changed to use a GET DIAGNOSTIC in case
    of SQLCODE +354, to display the first negative sqlcode and stop
    processing.
    39. Modules udbdsfic inzpabf udballoc were changed to generate
    a ddname different for each object unloaded in parallel.
    40. Module inzhyacc was changed to issue the correct error
    message.
    41. Module inzmyacc inzfyacc inzhyacc were changed to control
    the semicolon between 2 UNLOAD commands.
    42. Not a bug.
    43. Module inzctrl was changed to ignore the DB2 FORCE keyword
    when only a physical unload is coded.
    44. Not a bug.
    45. Not a bug.
    46. Not a bug.
    47. Modules inzcrxsq inzcrxsm inzpab were changed to issue a
    SET CURRENT DEGREE depending on the content of the ULDEGREE
    parmlib variable.
    48. Module udbcrrts was changed to issue message INZRE40 when
    finding some pages not in sequence.
    49. Modules inzctrlh olistdef and olistdef were changed to
    process correctly this case.
    50. Modules inztyacc olistdef and olistdef were changed to
    process correctly the CLONED YES in the LISTDEF statement.
    51. Procedure INZT02 was changed to free the files at the end
    of processing.
    52. Module inzhyacc inzpyacc inzctrlh inzctrlp and inzctrf were
    changed to fix these problems.
    53. Skeleton inzhpusk was changed to set the IVAR variable.
    

Problem conclusion

Temporary fix

Comments

  • APPLY the PTF.
    

APAR Information

  • APAR number

    PK40400

  • Reported component name

    DB2 HI PERF UNL

  • Reported component ID

    5697F4400

  • Reported release

    310

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-03-01

  • Closed date

    2007-05-29

  • Last modified date

    2007-07-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • INZM01
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R310 PSY UK25581

       UP07/06/09 P F706

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 Tools for z/OS
DB2 High Performance Unload

Software version:

3.1.0

Reference #:

PK40400

Modified date:

2007-07-03

Translate my page

Machine Translation

Content navigation