ibm-security/isam-support

ISAM Level II Support Diagnostic Tools, Configuration Examples, and Best-Practices.

isam-support's Issues

Remove 'Scripts with DB2 command below are are available from IBM Support' from tuning spreadsheet

Need to update the ISAM_Tuning spreadsheet to remove mention of tuning scripts from L2. Customers can manually run the commands or create their own scripts.

Tuning spreadsheet refers to the LMI for HVDB parameters that are really ATPs

I think the tuning spreadsheet has a bad reference. The three params are NOT listed in the LMI under Runtime Tuning Parameters. The spreadsheet needs to be updated to refer to these parameters as Advanced Tuning Parameters.

connectionTimeout
maxIdleTime
minPoolSize

The only parameter that is listed in the LMI under Runtime Tuning Parameters is the "Max Pool Size".

is the reference to table USER_DEVICE correct?

Are you sure the DEVICE_ID index and table USER_DEVICE is valid? That table does not exist in my HVDB.

row 26 of the spreadsheet:
db2 create index DEVICE_ID on USER_DEVICE(DEVICE_ID) COLLECT DETAILED STATISTICS;

Update Tuning Spreadsheet to have explicit units on AAC Advanced Tuning Parameters

Example would be the following parameter :

Appliance	ISAM Cluster	Config	https://{appliance_hostname}/mga/runtime_tuning   isam_cluster.config.connectionManager.connectionTimeout=20   isam_cluster.config.connectionManager.maxIdleTime=300   isam_cluster.config.connectionManager.maxPoolSize=400 (Removed)   isam_cluster.config.connectionManager.minPoolSize=10

These should have explicit units such as '300s' or '300m' as to have total confidence in the value set.

Update isamTop.sh to accept parameter for community

I was trying to use isamtop.sh last evening and ran into problems.
This morning I finally figured out that you have a hardcoded SNMP community string.
Could we parameterize that please?