IBM Support

IC87162: APPLICATION MAY RECEIVE SQLCODE -1307 RC 11 DURING DB2AUDIT ARCHIVE PROCESS DUE TIMING HOLE IN AUDIT RECORD I/O

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When the ERROR TYPE is set to AUDIT in the instance level
    configuration or database level policy, an application may fail
    with -1307 because of a timing hole in the audit record I/O
    which allows an audit archive operation to archive the active
    audit log file that has already been opened for audit record
    I/O.
    

Local fix

  • If you are not concerned about tracking DB2 audit failures
    which might result in lost of audit records, then setting ERROR
    TYPE to NORMAL in the instance level audit configuration and
    database level audit policies will result in DB2 ignoring all
    errors encountered by the DB2 audit facility.  This will allow
    an application to continue in the event this -1307 error occurs.
    
    For more information on the errortype setting, please read more
    at the following link:
    http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.
    luw.admin.cmd.doc/doc/r0002072.html
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7 Fixpack 8                                 *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 9.7 Fixpack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC87162

  • 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

    2012-10-11

  • Closed date

    2013-05-27

  • Last modified date

    2013-05-27

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

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

    IC89709 IC92201

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

Modified date: 27 May 2013