IBM Support

PI19605: RUN-STAT-CMD.BAT CANNOT CONNECT TO DATABASE IF DATABASE USER IS DIFFERENT THAN THE USER THAT INVOKES THE SCRIPT

A fix is available

7.1.0-TIV-ITCAMAD-FP0004: ITCAM for Application Diagnostics V7.1 Fix Pack 4

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The run-stat-cmd.bat accepts only a single argument, the DB2
database name:

db2 connect to %1

If the database is running as a different username/schema than
the user that invokes this script, the script is unable to
connect to the database and run.

This fix will be available in Managing Server 7.1.0.3 Ifix 9.

Local fix

  • Changing

db2 connect to %1
to
db2 connect to %1 user %2 using %3

is a correct way to allow run-stat-cmds.bat to work with MS
database user/password.


Please note that since the password is input as a command line
parameter (%3), it is a clear text one.

Problem summary

  • Fixed the run-stat-cmd.bat script

Problem conclusion

  • Fixed the run-stat-cmd.bat script

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI19605
    • 

  • Reported component name
    TCAM AD MAN SER
    • 

  • Reported component ID
    5724Y92MS
    • 

  • Reported release
    710
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2014-06-09
    • 

  • Closed date
    2014-09-16
    • 

  • Last modified date
    2015-04-13
    • 





    

  • 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
    TCAM AD MAN SER
    • 

  • Fixed component ID
    5724Y92MS
    • 



Applicable component levels


    

  • R710  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSDTFJ","label":"Tivoli Composite Application Manager for Application Diagnostics"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"710","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            27 July 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback