If you’ve lost track of the DB2 Fix Pack install date or simply want to reconfirm record logged on paper, then this db2ls command can help to find out and print it on screen.
NOTE: db2ls command is only available on DB2 v9 or above running on Linux platform.
Without using option switch,
If -c option switch is used, then result is output in CSV format (which is easier for programmatic parsing):
Where the delimiter is “:” and first field is “Install Path” followed by “Level”, “Fix Pack”, “Special Install Number”, and “Install Date”.
You can also get db2ls to find out DB2 product edition, by using these option switches:
NOTE: db2ls command is only available on DB2 v9 or above running on Linux platform.
Without using option switch,
db2ls prints result in an easy-to-read column-based format:If -c option switch is used, then result is output in CSV format (which is easier for programmatic parsing):
[walker@localhost] db2ls -c #PATH:VRMF:FIXPACK:SPECIAL:INSTALLTIME /opt/ibm/db2/V9.1:9.1.0.4:4 ::Mon Aug 2 15:15:43 2010 BST
Where the delimiter is “:” and first field is “Install Path” followed by “Level”, “Fix Pack”, “Special Install Number”, and “Install Date”.
You can also get db2ls to find out DB2 product edition, by using these option switches:
db2ls -q -p -b /opt/ibm/db2/V9.1
Custom Search
2013 •