IBM InfoSphere Federation Server, Version 10.5

Retrieving nickname statistics - examples

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', ?)

Feedback