IBM Support

IZ06545: DB2SUPPORT REPORTS ZRC=0X860F000A=-2045837302=SQLO_FNEX "FILE NOT FOUND.

Fixes are available

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When running db2support on any platform, the following error
message is seen in the db2diag.log:


2007-10-15-11.40.44.312336-240 E1122A537          LEVEL: Warning
(OS)
PID     : 1310830              TID  : 1           PROC :
db2support
INSTANCE: lzgotty              NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlochdir, probe:100
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.
CALLED  : OS, -, unspecified_system_function
OSERR   : ENOENT (2) "A file or directory in the path name does
not exist."
DATA #1 : File name, 29 bytes
/home/lzgotty/sqllib/sqlgwdir

2007-10-15-11.40.44.430680-240 E1660A535          LEVEL: Warning
(OS)
PID     : 1310830              TID  : 1           PROC :
db2support
INSTANCE: lzgotty              NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlochdir, probe:100
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.
CALLED  : OS, -, unspecified_system_function
OSERR   : ENOENT (2) "A file or directory in the path name does
not exist."
DATA #1 : File name, 27 bytes
/home/lzgotty/sqllib/spmlog

Local fix

  • No workaround.

Problem summary

  • ****************************************************************
* USERS AFFECTED:                                              *
* All users of the db2support command in DB2 9.1  FP4, FP3,    *
* FP2, FP1                                                     *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* The db2support command will generate an error in the         *
* db2diag.log file.                                            *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 V9.1 Fix Pack 5 or newer fix pack.            *
****************************************************************
When running db2support on any platform, the following error
message is seen in the db2diag.log:


2007-10-15-11.40.44.312336-240 E1122A537          LEVEL:
Warning(OS)
      PID     : 1310830              TID  : 1           PROC :
     db2support
    INSTANCE: lzgotty              NODE : 000
   FUNCTION: DB2 UDB, oper system services, sqlochdir, probe:100
  MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not
found."          DIA8411C A file "" could not be found.
      CALLED  : OS, -, unspecified_system_function
     OSERR   : ENOENT (2) "A file or directory in the path name
does not exist."
    DATA #1 : File name, 29 bytes
   /home/lzgotty/sqllib/sqlgwdir

 2007-10-15-11.40.44.430680-240 E1660A535          LEVEL:
Warning(OS)
      PID     : 1310830              TID  : 1           PROC :
     db2support
    INSTANCE: lzgotty              NODE : 000
   FUNCTION: DB2 UDB, oper system services, sqlochdir, probe:100
  MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not
found."          DIA8411C A file "" could not be found.
      CALLED  : OS, -, unspecified_system_function
     OSERR   : ENOENT (2) "A file or directory in the path name
does not exist."
    DATA #1 : File name, 27 bytes

Problem conclusion

  • First fixed in DB2 Version9.1, Fix Pack 5

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IZ06545
    • 

  • Reported component name
    DB2 UDB ESE SOL
    • 

  • Reported component ID
    5765F4102
    • 

  • Reported release
    910
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2007-10-15
    • 

  • Closed date
    2008-06-24
    • 

  • Last modified date
    2011-09-12
    • 





    

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

    • 

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

    
IZ19172 IZ19173 IZ19175
    

    • 



Fix information


    

  • Fixed component name
    DB2 UDB ESE SOL
    • 

  • Fixed component ID
    5765F4102
    • 



Applicable component levels


    

  • R910  PSY
       UP
    • 








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback