FYI...as this is probably undocumented.... (I had scripted jobs/macros that went against tables/columns...)... partial response to support: this coulda/shoulda been doc'd...opinion... changing cmd format...it has been debated that you'all own that... now select/db queries...seem to have been made fair game.... (our history)... I'll send a note to marist listserv for other customers...here's what I'll probably send:
Thanks Tim Williams pbsg DFW/Texas... TSM FOR AIX DIFFERENCES BETWEEN V4R2 LEVEL 2.0 AND TSM FOR AIX __________________ V5R1 LEVEL 6.1 2 NEW TABLES...(the I in the left column means inserted or new...to v5 TSM....D means deleted....). I - DISKS D - DRIVEMAPS I - SAN column differences (table listed on the left, column name on the right). (I in the left column means inserted or new to V5 TSM, D means deleted) I - DATAMOVERS WWN I - DATAMOVERS SERIAL I - DATAMOVERS COPYTHREADS I - DISKS NODE_NAME I - DISKS DISK_NAME I - DISKS WWN I - DISKS SERIAL I - DISKS ONLINE I - DISKS LAST_UPDATE_BY I - DISKS LAST_UPDATE D - DRIVEMAPS SERVICE_NAME D - DRIVEMAPS LIBRARY_NAME D - DRIVEMAPS DRIVE_NAME D - DRIVEMAPS DEVICE D - DRIVEMAPS ONLINE D - DRIVEMAPS DIRECTORY D - DRIVEMAPS LAST_UPDATE_BY D - DRIVEMAPS LAST_UPDATE D - DRIVES DEVICE I - DRIVES DRIVE_STATE D - LIBRARIES DEVICE I - LIBRARIES PRIMARY_LIB_MGR I - LIBRARIES AUTOLABEL D - LICENSES MGSYSLAN_ACT D - LICENSES MGSYSLAN_LIC D - LICENSES MGSYSSAN_ACT D - LICENSES MGSYSSAN_LIC I - LICENSES MGSYSLAN_ACT I - LICENSES MGSYSLAN_LIC I - LICENSES MGSYSSAN_ACT I - LICENSES MGSYSSAN_LIC I - LICENSES NDMP_ACT I - LICENSES NDMP_LIC I - NODES VALIDATEPROTOCOL I - NODES TCP_NAME I - NODES TCP_ADDRESS I - NODES GUID I - PATHS NODE_NAME I - PATHS EXTERNAL_MANAGER D - PATHS DEVICE_ID I - SAN DEVICE_TYPE I - SAN VENDOR I - SAN PRODUCT I - SAN SERIAL I - SAN DEVICE I - SAN IS_DATAMOVER I - SAN NODE_WWN I - SAN PORT_WWN I - SAN LUN I - SAN SCSI_PORT I - SAN SCSI_BUS I - SAN SCSI_TARGET I - SERVERS VALIDATEPROTOCOL I - SESSIONS MOUNT_POINT_WAIT I - SESSIONS INPUT_MOUNT_WAIT I - SESSIONS INPUT_VOL_WAIT I - SESSIONS INPUT_VOL_ACCESS I - SESSIONS OUTPUT_MOUNT_WAIT I - SESSIONS OUTPUT_VOL_WAIT I - SESSIONS OUTPUT_VOL_ACCESS D - SESSIONS MEDIA_STATE I - STATUS SERVERFREE_STATUS I - STATUS SERVERFREE_BATCH I - STGPOOLS COPYSTGPOOLS I - STGPOOLS COPYCONTINUE I - STGPOOLS CRCDATA I - SUMMARY COMM_WAIT