{"id":273417,"date":"2023-05-27T04:08:43","date_gmt":"2023-05-26T20:08:43","guid":{"rendered":"https:\/\/lrxjmw.cn\/lzkdbbzjbff.html"},"modified":"2023-05-27T04:08:43","modified_gmt":"2023-05-26T20:08:43","slug":"lzkdbbzjbff","status":"publish","type":"post","link":"https:\/\/lrxjmw.cn\/lzkdbbzjbff.html","title":{"rendered":"Linux\u67e5\u770bDB2\u7248\u672c\uff1a9\u79cd\u7b80\u4fbf\u65b9\u6cd5"},"content":{"rendered":"

\u4f17\u6240\u5468\u77e5\uff0cDB2\u662fIBM\u516c\u53f8\u7684\u4e00\u6b3e\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf<\/a>\u3002\u5728\u4f7f\u7528DB2\u65f6\uff0c\u6211\u4eec\u7ecf\u5e38\u9700\u8981\u4e86\u89e3\u5b83\u7684\u7248\u672c\u4fe1\u606f\u3002\u90a3\u4e48\uff0c\u5728 Linux<\/a>\u7cfb\u7edf\u4e0b\uff0c\u6211\u4eec\u8be5\u5982\u4f55\u67e5\u770bDB2\u7684\u7248\u672c\u5462\uff1f\u672c\u6587\u5c06\u4ecb\u7ecd9\u79cd\u65b9\u6cd5\u6765\u5b9e\u73b0\u8fd9\u4e00\u64cd\u4f5c\u3002<\/p>\n

\u65b9\u6cd5\u4e00\uff1adb2level\u547d\u4ee4<\/a><\/b><\/p>\n

db2level\u662f\u4e00\u4e2a\u7528\u4e8e\u663e\u793a\u5f53\u524dDB2\u7248\u672c\u4fe1\u606f\u7684\u547d\u4ee4\u3002\u5728\u7ec8\u7aef\u4e2d\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u5373\u53ef\u67e5\u770b\uff1a<\/p>\n

\ndb2level\n<\/pre>\n<\/p>\n\u8f93\u51fa\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
\n
\nDB21085I  Instance "db2inst1" uses DB2 code release "SQL11050" with level identifier "06010107".\nInformational tokens are "DB2 v11.5.0.0","s1911071100","DYN1911071100AMD64", and Fix Pack "0".\nProduct is installed at "\/opt\/ibm\/db2\/V11.5".\n<\/pre>\n<\/p>\n\u65b9\u6cd5\u4e8c\uff1adb2ls\u547d\u4ee4<\/b><\/p>\n
db2ls\u662f\u4e00\u4e2a\u7528\u4e8e\u663e\u793a\u5df2\u5b89\u88c5\u7684DB2\u7248\u672c\u4fe1\u606f\u7684\u547d\u4ee4\u3002\u5728\u7ec8\u7aef\u4e2d\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u5373\u53ef\u67e5\u770b\uff1a<\/p>\n
\n
\ndb2ls\n<\/pre>\n<\/p>\n<\/p>\n
\u8f93\u51fa\u7ed3\u679c\u7c7b\u4f3c\u4e8e\uff1a<\/p>\n
\n
\nInstall Path                       Level   Fix Pack   Special Install Number   Install Date   Installer UID\n---------------------------------------------------------------------------------------------------------------\n\/opt\/ibm\/db2\/V11.1                11.1.0.0        0                               Wed Jun 15 13:12:50 2016 CST    db2inst1\n\/opt\/ibm\/db2\/V11.5                11.5.0.0        0                               Thu Nov  7 11:05:10 2019 CST    db2inst1\n<\/pre>\n<\/p>\n\u65b9\u6cd5\u4e09\uff1adb2licm\u547d\u4ee4<\/b><\/p>\n
db2licm\u662f\u4e00\u4e2a\u7528\u4e8e\u663e\u793aDB2\u8bb8\u53ef\u8bc1\u4fe1\u606f\u7684\u547d\u4ee4\u3002\u5728\u7ec8\u7aef\u4e2d\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u5373\u53ef\u67e5\u770b\uff1a<\/p>\n
\n
\ndb2licm -l\n<\/pre>\n<\/p>\n\u8f93\u51fa\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
\n
\nProduct name                  :"DB2 Enterprise Server Edition"\nLicense type                  :"CPU Option"\nExpiry date                   :"Permanent"\nProduct identifier           :"db2ese"\nVersion information           :"11.5"\nMax number of licensed CPUs   :"16"\nMax amount of memory (GB)     :"64"\nEnforcement policy            :"Soft Stop"\n<\/pre>\n<\/p>\n\u65b9\u6cd5\u56db\uff1adb2ckpwd\u547d\u4ee4<\/b><\/p>\n
db2ckpwd\u662f\u4e00\u4e2a\u7528\u4e8e\u68c0\u67e5DB2\u5bc6\u7801\u6587\u4ef6\u7248\u672c\u4fe1\u606f\u7684\u547d\u4ee4\u3002\u5728\u7ec8\u7aef\u4e2d\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u5373\u53ef\u67e5\u770b\uff1a<\/p>\n
\n
\ndb2ckpwd -v\n<\/pre>\n<\/p>\n\u8f93\u51fa\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
\n
\nDBI1281I  The DB2CKPWD command is running.\nThe password file version is '3'.\nThe password file was last modified on '2023-05-27-22.36.42.000000'.\nDBI1282I  The DB2CKPWD command completed successfully.\n<\/pre>\n<\/p>\n\u65b9\u6cd5\u4e94\uff1adb2diag\u547d\u4ee4<\/b><\/p>\n
db2diag\u662f\u4e00\u4e2a\u7528\u4e8e\u663e\u793aDB2\u8bca\u65ad\u65e5\u5fd7\u6587\u4ef6\u7248\u672c\u4fe1\u606f\u7684\u547d\u4ee4\u3002\u5728\u7ec8\u7aef\u4e2d\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u5373\u53ef\u67e5\u770b\uff1a<\/p>\n
\n
\ndb2diag -V\n<\/pre>\n<\/p>\n\u8f93\u51fa\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
<\/p>\n
\n
\nIBM DB2 Diagnostic Log File Version:3.0\n<\/pre>\n<\/p>\n\u65b9\u6cd5\u516d\uff1adb2dart\u547d\u4ee4<\/b><\/p>\n
db2dart\u662f\u4e00\u4e2a\u7528\u4e8e\u663e\u793aDB2\u6570\u636e\u6062\u590d\u5de5\u5177\u7248\u672c\u4fe1\u606f\u7684\u547d\u4ee4\u3002\u5728\u7ec8\u7aef\u4e2d\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u5373\u53ef\u67e5\u770b\uff1a<\/p>\n
\n
339ac1cc3683d79c7c0382bc61db2904-version\n<\/pre>\n<\/p>\n\u8f93\u51fa\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
\n
\nIBM DB2 Data Recovery and High Availability Tool\nVersion 11.5.0.0 Build level s1911071100\n<\/pre>\n<\/p>\n\u65b9\u6cd5\u4e03\uff1adb2ckbkp\u547d\u4ee4<\/b><\/p>\n
db2ckbkp\u662f\u4e00\u4e2a\u7528\u4e8e\u663e\u793a\u5907\u4efd\u6587\u4ef6\u7248\u672c\u4fe1\u606f\u7684\u547d\u4ee4\u3002\u5728\u7ec8\u7aef\u4e2d\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u5373\u53ef\u67e5\u770b\uff1a<\/p>\n
\n
\ndb2ckbkp -h\/path\/to\/backup\/file\n<\/pre>\n<\/p>\n\u8f93\u51fa\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
\n
\nBackup image type:         Database\nBackup image subtype:      Full\nBackup image timestamp:    220\nBackup image format:       TSM\nBackup image size (bytes): 123456789\nDatabase name:             SAMPLEDB\nDatabase partition number: 0\nDatabase release ID:       SQL11050\nDatabase version:          v11.5.0.0(s1911071100)\nCompatibility vector:      1.1.1.1\n<\/pre>\n<\/p>\n\u65b9\u6cd5\u516b\uff1adb2pd\u547d\u4ee4<\/b><\/p>\n
db2pd\u662f\u4e00\u4e2a\u7528\u4e8e\u663e\u793aDB2\u6570\u636e\u5e93\u5feb\u7167\u4fe1\u606f\u7684\u547d\u4ee4\u3002\u5728\u7ec8\u7aef\u4e2d\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u5373\u53ef\u67e5\u770b\uff1a<\/p>\n
\n
\ndb2pd -version\n<\/pre>\n<\/p>\n\u8f93\u51fa\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
\n
\n\/opt\/ibm\/db2\/V11.5\/bin\/db2pd -version\n db2pd - IBM DB2 Information Utility Version 11.5.0\n<\/pre>\n<\/p>\n\u65b9\u6cd5\u4e5d\uff1a\u67e5\u8be2DB2\u7248\u672c\u6587\u4ef6<\/b><\/p>\n
\u5728Linux\u7cfb\u7edf\u4e2dlinux\u547d\u4ee4\u67e5\u770bdb2\u7248\u672c<\/strong>linux\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c\uff0cDB2\u7248\u672c\u4fe1\u606f\u5b58\u50a8\u5728\u4ee5\u4e0b\u6587\u4ef6\u4e2d\uff1a<\/p>\n
\n
\n\/opt\/ibm\/db2\/Vxx.x\/release\/servicename\/db2level\n<\/pre>\n<\/p>\n\u5176\u4e2d\uff0cVxx.x\u8868\u793aDB2\u7684\u7248\u672c\u53f7linux\u547d\u4ee4\u67e5\u770bdb2\u7248\u672c<\/strong>\uff0cservicename\u8868\u793aDB2\u7684\u670d\u52a1\u540d\u79f0\u3002\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u547d\u4ee4\u6765\u67e5\u770b\uff1a<\/p>\n
\n
\ncat \/opt\/ibm\/db2\/V11.5\/release\/ese\/db2level\n<\/pre>\n<\/p>\n\u8f93\u51fa\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
\n
\nDB21085I  Instance "db2inst1" uses DB2 code release "SQL11050" with level identifier "06010107".\nInformational tokens are "DB2 v11.5.0.0","s1911071100","DYN1911071100AMD64", and Fix Pack "0".\nProduct is installed at "\/opt\/ibm\/db2\/V11.5".\n<\/pre>\n<\/p>\n\u5230\u8fd9\u91ccpuppy linux\uff0c\u6211\u4eec\u5df2\u7ecf\u4ecb\u7ecd\u4e869\u79cd\u65b9\u6cd5\u6765\u67e5\u770bLinux\u7cfb\u7edf\u4e0b\u7684DB2\u7248\u672c\u4fe1\u606f\u3002\u5e0c\u671b\u8fd9\u7bc7\u6587\u7ae0\u80fd\u591f\u5bf9\u60a8\u6709\u6240\u5e2e\u52a9\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
db2ls\u662f\u4e00\u4e2a\u7528\u4e8e\u663e\u793a\u5df2\u5b89\u88c5\u7684DB2\u7248\u672c\u4fe1\u606f\u7684\u547d\u4ee4\u3002db2ckpwd\u662f\u4e00\u4e2a\u7528\u4e8e\u68c0\u67e5DB2\u5bc6\u7801\u6587\u4ef6\u7248\u672c\u4fe1\u606f\u7684\u547d\u4ee4\u3002db2diag\u662f\u4e00\u4e2a\u7528\u4e8e\u663e\u793aDB2\u8bca\u65ad\u65e5\u5fd7\u6587\u4ef6\u7248\u672c\u4fe1\u606f\u7684\u547d\u4ee4\u3002db2ckbkp\u662f\u4e00\u4e2a\u7528\u4e8e\u663e\u793a\u5907\u4efd\u6587\u4ef6\u7248\u672c\u4fe1\u606f\u7684\u547d\u4ee4\u3002\u65b9\u6cd5\u4e5d\uff1a\u67e5\u8be2DB2\u7248\u672c\u6587\u4ef6\u5728Linux\u7cfb\u7edf\u4e2d\uff0cDB2\u7248\u672c\u4fe1\u606f\u5b58\u50a8\u5728\u4ee5\u4e0b\u6587\u4ef6\u4e2d\uff1a\u5230\u8fd9\u91cc\uff0c\u6211\u4eec\u5df2\u7ecf\u4ecb\u7ecd\u4e869\u79cd\u65b9\u6cd5\u6765\u67e5\u770bLinux\u7cfb\u7edf\u4e0b\u7684DB2\u7248\u672c\u4fe1\u606f\u3002<\/p>\n","protected":false},"author":1,"featured_media":273418,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[988],"tags":[999],"class_list":["post-273417","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tougao","tag-999"],"acf":[],"_links":{"self":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/273417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/comments?post=273417"}],"version-history":[{"count":0,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/273417\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media\/273418"}],"wp:attachment":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media?parent=273417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/categories?post=273417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/tags?post=273417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}