IBM Support

IZ55725: On SQL Server 2008, the sqlsvrDbFilesTable and sqlsvrCacheMgrTab le are both empty

Readmes are available

IBM Tivoli 4.0.0-TIV-SSM-FP0010
IBM Tivoli 4.0.0-TIV-SSM-FP0011
IBM Netcool System Service Monitor SSM 4.0 Fix Pack 12 README 4.0.0-TIV-SSM-FP0012
IBM Netcool System Service Monitor SSM 4.0 Fix Pack 13 README 4.0.0-TIV-SSM-FP0013
IBM Netcool System Service Monitor SSM 4.0 Fix Pack 14 README 4.0.0-TIV-SSM-FP0014
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 1 README 4.0.0.14-TIV-SSM-IF0001
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 2 README 4.0.0.14-TIV-SSM-IF0002
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 3 README 4.0.0.14-TIV-SSM-IF0003
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 4 README 4.0.0.14-TIV-SSM-IF0004
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 5 README 4.0.0.14-TIV-SSM-IF0005
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 6 README 4.0.0.14-TIV-SSM-IF0006
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 7 README 4.0.0.14-TIV-SSM-IF0007
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 8 README 4.0.0.14-TIV-SSM-IF0008
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 1 README 4.0.0.15-TIV-SSM-IF0001

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Running the SQLSvr ASM which is part of SSM 4.0 (FP7) on
Microsoft SQL Server 2008 produces no data for
sqlsvrDbFilesTable and sqlsvrCacheMgrTable. The same release
running with SQL Server 2005 works.

Local fix

  • 



Problem summary


    

  • ****************************************************************
USERS AFFECTED:
Users of SSM 4.0 with Microsoft SQL Server 2008.
****************************************************************
PROBLEM DESCRIPTION:
Running the SQLSvr ASM which is part of SSM 4.0 (FP7) on
Microsoft SQL Server 2008 produces no data for
sqlsvrDbFilesTable and sqlsvrCacheMgrTable. The same release
running with SQL Server 2005 works.
****************************************************************
RECOMMENDATION:
Upgrade to Fix Pack 8 for SSM 4.0
****************************************************************

    



Problem conclusion


    

  • The fix for this APAR is contained in the following maintenance
packages:
| fix pack | 4.0.0-TIV-SSM-FP0008

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IZ55725
    • 

  • Reported component name
    NETCOOL SYS SVC
    • 

  • Reported component ID
    5724P4300
    • 

  • Reported release
    400
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2009-07-22
    • 

  • Closed date
    2009-07-27
    • 

  • Last modified date
    2009-07-27
    • 





    

  • 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
    NETCOOL SYS SVC
    • 

  • Fixed component ID
    5724P4300
    • 



Applicable component levels


    

  • R400  PSN
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCP7NT","label":"Netcool System Service Monitor"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"400","Edition":"","Line of Business":{"code":"","label":""}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            27 July 2009
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback