Weekly Tips from DB2 Experts: Explore db2cli - DB2 interactive CLI command
Subbu Prabhu 060001JD9S Visits (7734)
To troubleshoot an issue with complex CLI application, DB2 CLI script with similar functionality can be used.
In many cases, customers usually have a complex CLI application that run into issues.
Here are some Windows based examples:
1. To test the CLI connectivity to the remote database from the DB2 Client where the application runs
2. To check the performance of a query:
opt calldiag on
To run the scripts:
1) Replace the dsnname, uid, pwd with yours and save it as <filename>.
If the issue is reproducible using the above script, then collect data as explained here.