OBIEE 11.1.1 - Advanced Usage of nqcmd command
By Ahmed Awan-Oracle on Feb 27, 2014
Following are the useful nqcmd command lines arguments:
a. In your environment set the "export SA_NQCMD_ADVANCED=yes"
b. Following is the description of the nqcmd command line arguments for BIServer (nqsserver) testing:
-d = Datasource.
-u = username.
-p = password.
-s = inputsqlsfile.
-o = outputfile. counters will be in outputfile_Counters.txt.
-td <secs> = timeduration in secs. nqcmd will run until <secs> elapses.
-qsel r = select queries random manner from inputsqlsfile.
-ds <secs> = dump statistics to outputfile_Counters.txt every <secs>.
-T = Timer is on. Otherwise you won’t get correct statistics.
-t <number> = generate users . if you give -t 50, 50 users will be there.
-q = turn off row output - mandatory flag for load testing.
-n <number> = used for login test run for <number> iterations.
-w = thinktime (in seconds).
For example: The following command runs 50 users and runs for 200secs , this will use logical.sql as input file and fire queries randomly as we select -qsel r. it dumps statistics to stats_sessions_Counters.txt for every 20 secs. the nqcmd for load testing will append _Counters.txt to filename given by -o option:
./nqcmd -d AnalyticsWeb -u weblogic -p welcome1 -s logical.sql -o stats_sessions -td 200 -qsel r -ds 20 -q -T -t 50 -utf16
Sample output of nqcmd and interpretation
TotalSqls/TimeinSecs gives sqls/sec .
CumulativeRT/TotalSqls gives Avg RT
TimeStamp TotalSqls CumulativeRT CumulativePrepareTime CumulativeExecuteTime CumulativeFetchTime
00:00:20 62 84.88 19.40 17.55 47.93
00:00:40 124 181.07 44.17 38.66 98.24