IBM Support

IZ33716: ON STANDBY DATABASE, "THIS OPERATION IS NOT ALLOWED ON A STANDBY DATABASE" MESSAGE APPEARS AS SEVERE MESSAGE.

Fixes are available

DB2 Version 9.1 Fix Pack 7  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

  • db2diag.log can get following severe messages on stand by
database if some application is trying to connect to standby
database.


2008-08-08-13.38.44.000000-240 I342920295A514     LEVEL: Severe
PID     : 1   TID  : 1           PROC : db2agent(IBMDB) 0
INSTANCE: db2inst1             NODE : 000
APPHDL  : 0-2449               APPID:
*LOCAL.db2inst1.080818183844
AUTHID  : UDBPA101
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrCheckDb,
probe:18300
MESSAGE : This operation (0) is not allowed on a standby
database.
DATA #1 : Hexdump, 4 bytes
0x00000001111A126C : FFFF F910


Above messages are expected. However, they need to be Warning
messages.

Local fix

  • NO Local fix availabe. users can ignore the messages.

Problem summary

  • Users Affected: ALL

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 7

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IZ33716
    • 

  • Reported component name
    DB2 EDE AIX
    • 

  • Reported component ID
    5724N7600
    • 

  • Reported release
    910
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2008-10-01
    • 

  • Closed date
    2009-04-08
    • 

  • Last modified date
    2009-04-08
    • 





    

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

    • 

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

    
IZ33770
    

    • 



Fix information


    

  • Fixed component name
    DB2 EDE AIX
    • 

  • Fixed component ID
    5724N7600
    • 



Applicable component levels


    

  • R910  PSY
       UP
    • 

  • R950  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:
            

            04 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback