IBM Support

LI73884: IF DB2 AUDIT FACILITY HITS DISK FULL, SQL1042C RETURNS. NO NEW DATABASE CONNECTION CAN BE MADE UNTIL DB2 SERVER IS RESTARTED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If DB2 Audit Facility hits disk full when writing to
    db2audit.log file, SQL1042C returns to both existing connections
    and new connections.  The db2diag.log could show messages
    similar to the following if there is still disk space for
    db2diag.log entries:
    
    2008-11-11-16.48.43.282953-300 I7812A443          LEVEL: Error
    PID     : 18137                TID  : 2199112058752PROC :
    db2agent (ABC)
    INSTANCE: dbguest1             NODE : 000         DB   : ABC
    APPHDL  : 0-7                  APPID:
    *LOCAL.dbguest1.081111214613
    AUTHID  : DBGUEST1
    FUNCTION: DB2 UDB, bsu security, sqlex_write_log_record,
    probe:70
    RETCODE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
              DIA8312C Disk was full.
    
    2008-11-11-16.48.43.287746-300 I8256A476          LEVEL: Error
    PID     : 18137                TID  : 2199112058752PROC :
    db2agent (ABC)
    INSTANCE: dbguest1             NODE : 000         DB   : ABC
    APPHDL  : 0-7                  APPID:
    *LOCAL.dbguest1.081111214613
    AUTHID  : DBGUEST1
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
    MESSAGE : Audit error.  sqlcode is:
    DATA #1 : Hexdump, 4 bytes
    0x000003FFFFFED234 : FFFF FBEE
    ....
    
    
    2008-11-11-16.48.43.292140-300 I8733A434          LEVEL: Severe
    PID     : 18137                TID  : 2199112058752PROC :
    db2agent (ABC)
    INSTANCE: dbguest1             NODE : 000         DB   : ABC
    APPHDL  : 0-7                  APPID:
    *LOCAL.dbguest1.081111214613
    AUTHID  : DBGUEST1
    FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:55
    RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
              "SQLCA has already been built"
    
    Even if disk space for db2audit.log file is available
    afterwards, new database connection still can not be made, and
    recieves SQL30060N. If you attempt db2audit flush, it fails with
    AUD0018N.
    
    Only after disk space for db2audit.log file is available, DB2
    Server is stoped and restarted again, then new database
    connection can be made.
    

Local fix

Problem summary

  • IF DB2 AUDIT FACILITY HITS DISK FULL, SQL1042C RETURNS. NO NEW
    DATABASE CONNECTION CAN BE MADE UNTIL DB2 SERVER IS RESTARTED.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73884

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-18

  • Closed date

    2009-04-07

  • Last modified date

    2009-04-07

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

    LI73883

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

    LI73885

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 October 2021