【原创】如何获取DB2在主机上的安装信息（实例，数据库）
最好的办法：使用DB2GREG命令获取全局注册表变量信息。在UNIX/LINUX环境中，文件路径为：/var/db2/global.reg。是二进制的文件，可以用strings命令来看，最好使用db2greg -dump格式化：
dbhis:/home/dbhis >db2greg -dump|more
S,DB2,9.5.0.5,/opt/IBM/db2/V9.5,,,5,0,,75352554,0
I,DB2,9.5.0.5,tlbrief,/home/tlbrief/sqllib,,1,0,/opt/IBM/db2/V9.5,,
I,DB2,9.5.0.5,bat,/app/bat/sqllib,,1,0,/opt/IBM/db2/V9.5,,
I,DB2,9.5.0.5,tfr,/app/tfr/sqllib,,1,0,/opt/IBM/db2/V9.5,,
I,DB2,9.5.0.5,dbbke,/home/dbbke/sqllib,,1,0,/opt/IBM/db2/V9.5,,
I,DB2,9.1.0.8,dbhis,/home/dbhis/sqllib,,1,0,/opt/IBM/db2/V9.1,,
I,DB2,9.5.0.5,posdbonl,/home/posdbonl/sqllib,,1,0,/opt/IBM/db2/V9.5,,
S,DB2,9.7.0.5,/opt/IBM/db2/V9.7,,,5,0,,1338927558,0
V,DB2GPRF,DB2SYSTEM,test1,/opt/IBM/db2/V9.7
I,DB2,9.7.0.5,dbonl,/home/dbonl/sqllib,,1,0,/opt/IBM/db2/V9.7,,
V,DB2GPRF,DB2FCMCOMM,TCPIP4,/opt/IBM/db2/V9.7
I,DB2,9.7.0.5,exp,/home/exp/sqllib,,1,0,/opt/IBM/db2/V9.7,,
S,DB2,9.1.0.8,/opt/IBM/db2/V9.1,,,8,0,,1350028371,0
S,DB2,9.5.0.5,/opt/IBM/db2/V9.5,,,5,0,,75352554,0
I,DB2,9.5.0.5,tlbrief,/home/tlbrief/sqllib,,1,0,/opt/IBM/db2/V9.5,,
I,DB2,9.5.0.5,bat,/app/bat/sqllib,,1,0,/opt/IBM/db2/V9.5,,
I,DB2,9.5.0.5,tfr,/app/tfr/sqllib,,1,0,/opt/IBM/db2/V9.5,,
I,DB2,9.5.0.5,dbbke,/home/dbbke/sqllib,,1,0,/opt/IBM/db2/V9.5,,
I,DB2,9.1.0.8,dbhis,/home/dbhis/sqllib,,1,0,/opt/IBM/db2/V9.1,,
I,DB2,9.5.0.5,posdbonl,/home/posdbonl/sqllib,,1,0,/opt/IBM/db2/V9.5,,
S,DB2,9.7.0.5,/opt/IBM/db2/V9.7,,,5,0,,1338927558,0
V,DB2GPRF,DB2SYSTEM,test1,/opt/IBM/db2/V9.7
I,DB2,9.7.0.5,dbonl,/home/dbonl/sqllib,,1,0,/opt/IBM/db2/V9.7,,
V,DB2GPRF,DB2FCMCOMM,TCPIP4,/opt/IBM/db2/V9.7
I,DB2,9.7.0.5,exp,/home/exp/sqllib,,1,0,/opt/IBM/db2/V9.7,,
S,DB2,9.1.0.8,/opt/IBM/db2/V9.1,,,8,0,,1350028371,0
机器上安装了哪些软件版本，有几个实例（客户端）环境，对应用户与实例目录等，一应俱全。
当然查看实例你也可以通过在DB2的某个用户下运行db2ilist得到。当然，所有用户都有执行db2ilist命令的权利，前提是你到对应的目录下，默认为: /opt/IBM/db2/V9.7/bin
如何查看有几个实例启动了？ps -ef|grep sysc即可。
如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！
赞0Ctrl+Enter 发表
作者其他文章
评论 2 · 赞 0
评论 0 · 赞 1
评论 0 · 赞 0
评论 6 · 赞 2
评论 0 · 赞 0
添加新评论0 条评论