Troubleshooting
Problem
This technote shows how to check when the last time DB2 statistics were generated for an ITDS backend database. This is a very important activity for maintaining the health and performance of an ITDS server.
Resolving The Problem
Here's SQL that you can run to check to see the last time a db2 runstats was performed.
db2 connect to <ldap_db_name>
db2 "select STATS_TIME from syscat.tables where tabname='<TABLENAME>'"
db2 connect reset
(Since the ITDS runstats/idsrunstats runs against all tables in the database, it suffices to check any table. See the example below.
Here's an example:
db2 connect to ldapdb2
Database Connection Information
Database server = DB2/AIX64 8.2.7
SQL authorization ID = LDAPDB2
Local database alias = LDAPDB2
db2 "select stats_time from syscat.tables where tabname = 'OBJECTCLASS'"
STATS_TIME
--------------------------
2007-06-13-11.50.06.657049
1 record(s) selected.
See the ITDS Performance Tuning guide for instructions on correctly updating DB2 statistics for an ITDS backend database:
http://publib.boulder.ibm.com/infocenter/tivihelp/v2r1/index.jsp?topic=/com.ibm.IBMDS.doc/tuning.htm
Product Synonym
ITDS;Secureway;TDS;IBM Tivoli Directory Server
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21263995