These examples show how to retrieve nickname statistics from the
command line by using the SYSPROC.NNSTAT stored procedure.
Example: Retrieving all statistics
The federated
server retrieves the statistics for the nicknames on the DB2SERV server and
does not create a log.
CALL SYSPROC.NNSTAT('DB2SERV',NULL,NULL,NULL,NULL,0,NULL,?)
Retrieving all statistics for a schema and returning a log
Example: Retrieving statics with the catalog-based method
The
federated server retrieves the statistics for the nickname STAFF in the ADMIN
schema. Statistics are gathered for columns 1 through 5 and indexes 1 and
2. The catalog-based method is used to collect statistics. The federated server
writes the log to the /home/iiuser/reportlogs/log1.txt file.
CALL SYSPROC.NNSTAT(
NULL, 'ADMIN','STAFF','COL1, COL2, COL3, COL4, COL5','IND1, IND2',1,
'/home/iiuser/reportlogs/log1.txt',?)
In this example, the federated server retrieves the statistics
for all the nicknames on the DB2Serv server in the admin schema. The federated
server writes the log to the /home/iiuser/stats/recent.log file.
CALL SYSPROC.NNSTAT(
'DB2Serv', 'admin', NULL, NULL, NULL, 0, '/home/iiuser/stats/recent.log', ?)
