IBM Support

IC78485: DB2 IMPORT FAILS WHEN EXTRA LINE FEED CHARACTER EXISTS IN THE COMMAND

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When using the db2 import command, it will fail if an extra
    line feed character (0x0A) is added in the command.
    
    The following for example will fail:
    
    db2 "IMPORT FROM /home/db2inst1/importdata/test_import.dat OF
    DEL
    >   MODIFIED BY COLDEL|
    > METHOD P ( 1 , 2)
    > INSERT INTO TEST_IMPORT
    > (COL1,COL2)"
    
    
    In this case, the problem is caused by the line feed character
    after TEST_IMPORT.
    
    
    The operation will fail with the following error:
    
    SQL2018N  The utility encountered an error "" while attempting
    to verify the user's authorization ID or database
    authorizations.
    
    
    This can also be reproduced using the SYSPROC.ADMIN_CMD()
    command.   If the 'import' command is placed inside that
    routine, it will fail as long as there is a line feed character
    in
    the command.
    

Local fix

  • Removing the line feed character, and placing the entire command
    in
    one line will workaround the problem.   The placement of the
    line feed character may allow the command to work without have
    to
    put the entire command in one line, but to avoid hitting this
    APAR it is recommended to avoid using a line feed.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7, Fixpak 6                         *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7, Fixpak 6
    

Temporary fix

  • see Local Fix
    

Comments

APAR Information

  • APAR number

    IC78485

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-02

  • Closed date

    2012-06-15

  • Last modified date

    2012-06-15

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC78485

Modified date: 15 June 2012