IBM Support

IC92693: SYSPROC.NNSTAT PROCEDURE CAN FAIL IF USING METHOD 2 WITH SQL0206N ERROR.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • With federated object and running SYSPROC.NNSTAT with the Method
    2 option, we can fail with SQL0206N.
    
    eg.
    $db2 "set passthru MS1"
    DB20000I  The SQL command completed successfully.
    
    $db2 "drop table dbo.DATA_TMP"
    DB20000I  The SQL command completed successfully.
    
    $db2 "CREATE TABLE dbo.DATA_TMP ( INJECTEDSECURITYID int
    NOT NULL, FIELDID            int          NOT NULL, VALDATE
    datetime     NULL, NUMVALUE           varchar(255) COLLATE
    SQL_Latin1_General_CP1_CI_AS NULL, REFVALUEID         int
    NULL, VALIDFROM          datetime     NULL, VALIDTO
    datetime     NULL, SECURITYID         int          NOT NULL,
    CONSTRAINT PK_data_TMP PRIMARY KEY CLUSTERED
    (INJECTEDSECURITYID,FIELDID,SECURITYID) WITH ( FILLFACTOR = 90 )
    )"
    DB20000I  The SQL command completed successfully.
    
    $db2 "set passthru reset"
    DB20000I  The SQL command completed successfully.
    
    $db2 "drop nickname nt2"
    DB21034E  The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command.  During SQL processing it
    returned:
    SQL0204N  "IIDEV4.NT2" is an undefined name.  SQLSTATE=42704
    
    $db2 'CREATE NICKNAME "NICK_COMMON"."DATA_TMP" FOR
    "MS1"."dbo"."DATA_TMP"'
    DB20000I  The SQL command completed successfully.
    
    $db2 "CALL
    SYSPROC.NNSTAT('MS1','NICK_COMMON','DATA_TMP','FIELDID',NULL,2,N
    ULL,?)"
    SQL0206N  "NICK_COMMON" is not valid in the context where it is
    used.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgraed to v9.7 Fixpack 9 or Higher                          *
    ****************************************************************
    

Problem conclusion

  • First Fixed in v9.7 Fixpack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC92693

  • 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

    2013-05-31

  • Closed date

    2013-12-16

  • Last modified date

    2013-12-16

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

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

    IC95402 IC96283

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 #: IC92693

Modified date: 16 December 2013