IBM Support

IT19687: DB2 upgrade may hit error SQL1762N even though there is sufficient disk space for upgrade

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 upgrade may hit error SQL1762N even though there is
    sufficient disk space for upgrade.
    
       Here is the specific error message:
       $ db2 upgrade database MYDB
       SQL1762N Unable to connect to database because there is not
    enough
       space to allocate active log files. SQLSTATE=08004
    
    The diaglog will show the following:
    
    
    
    2017-03-01-16.13.45.142221-420 I70744A944           LEVEL: Error
    PID     : 17367116             TID : 4628           PROC :
    db2sysc 0
    INSTANCE: tsminst1             NODE : 000           DB   : MYDB
    APPHDL  : 0-7                  APPID:  MYAPPID
    AUTHID  : MYAUTH             HOSTNAME: MYHOSTNAME
    EDUID   : 4628                 EDUNAME: db2agent (TSMDB1) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgReallocLogs,
    probe:970
    MESSAGE : ZRC=0x85100084=-2062548860=SQLP_NO_SPACE_FOR_LOG
              "Not enough space to create primary logs"
    DATA #1 : String, 37 bytes
    Log path / Re-Usable space (bytes) /
    DATA #2 : String, 48 bytes
    Free space (bytes) / Log space required (bytes):
    DATA #3 : String, 49 bytes
    /tsm/server/aLog1/IVTalog/NODE0000/LOGSTREAM0000/
    DATA #4 : unsigned integer, 8 bytes
    537927680
    DATA #5 : unsigned integer, 8 bytes
    11259609088
    DATA #6 : unsigned integer, 8 bytes
    
    
    .
    

Local fix

  • Add more disk space
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 11.1 Fix Pack 1                               *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 11.1 Fix Pack 1
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT19687

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-14

  • Closed date

    2017-05-09

  • Last modified date

    2017-05-09

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
29 June 2020