{"id":788,"date":"2015-08-23T18:09:11","date_gmt":"2015-08-23T17:09:11","guid":{"rendered":"http:\/\/it.tuxie.eu\/?p=788"},"modified":"2015-08-24T12:28:14","modified_gmt":"2015-08-24T11:28:14","slug":"db2-10-5-6-db2val-failing-afer-install","status":"publish","type":"post","link":"http:\/\/it.tuxie.eu\/?p=788","title":{"rendered":"DB2 10.5.6 – db2val failing afer fresh install"},"content":{"rendered":"

That feeling you have brand new version. Very common setup, after install steps. And surprise!! db2val is yelling „discrepancies found“! \ud83d\ude42<\/p>\n

<\/p>\n

DB2 is distributed with a very useful utility called db2val<\/a> – it checks and validate installed DB2 files + proper setup of instance.
\n[crayon lang=“shell“]
\n[db2inst1@ol67 ~]$ db2val
\nDBI1379I\u00a0 The db2val command is running. This can take several minutes.<\/p>\n

DBI1335I\u00a0 Installation file validation for the DB2 copy installed at
\n\/opt\/ibm\/db2\/V10.5 was successful.<\/p>\n

DBI1338E\u00a0 The validation of instance db2inst1 failed. Reason
\ncode=3.<\/p>\n

Explanation:<\/p>\n

1. The default instance is not set.
\n2. Some files in the instance directory are damaged. The symbolic links
\nof the files are not pointing to the current DB2 copy installation
\npath, and the file permission and ownership might have been changed.
\n3. The DB2 Extended Security setup does not allow the current user to
\nstart an instance. If Extended Security is enabled, the user needs to
\nbe in the DB2ADMNS group.
\n4. To start the instance, read permission is required to the
\n\/etc\/services file.
\n5. The appropriate authority is required to validate this instance.
\n6. The partitioned database environment setting is not correct.
\n7. The instance failed to start because of system errors.
\n8. An unexpected internal error occurred.<\/p>\n

User response:<\/p>\n

1. Set the DB2INSTDEF profile registry variable to an instance in the
\nDB2 copy.
\n2. Run the db2iupdt or db2nrupdt command with the -k option for the
\ninstance.
\n3. Add the current user to the DB2ADMNS group and rerun the command.
\n4. Ensure you have read permission to the \/etc\/services file.
\n5. Log on as a user with the appropriate authority, and retry the
\ncommand.
\n6. Check the partitioned database environment validation log file for
\ndetails.
\n7. Check the log file for details.
\n8. Rerun the db2val command. If this error persists, contact your IBM
\nservice representative.<\/p>\n

Related information:
\ndb2val – DB2 copy validation tool command<\/p>\n

DBI1344E\u00a0 The validation tasks of the db2val command failed. For
\ndetails, see the log file \/tmp\/db2val-150823_181041.log.
\n[\/crayon]
\nOk, there are just 2 steps to correct „something“:<\/p>\n

A) db2iupdt<\/a> can a bit tricky one = run only as a root and be sure that affected instance is down.<\/p>\n

B) location of db2iupdt is instance directory withing DB2 home:
\n[crayon lang=“shell“]
\n[root@ol67 j]# cd \/opt\/ibm\/db2\/V10.5\/instance
\nroot@ol67 instance]# .\/db2iupdt -k db2inst1
\nDBI1446I\u00a0 The db2iupdt command is running.<\/p>\n

DB2 installation is being initialized.<\/p>\n

Total number of tasks to be performed: 4
\nTotal estimated time for all tasks to be performed: 309 second(s)<\/p>\n

Task #1 start
\nDescription: Setting default global profile registry variables
\nEstimated time 1 second(s)
\nTask #1 end<\/p>\n

Task #2 start
\nDescription: Initializing instance list
\nEstimated time 5 second(s)
\nTask #2 end<\/p>\n

Task #3 start
\nDescription: Configuring DB2 instances
\nEstimated time 300 second(s)
\nTask #3 end<\/p>\n

Task #4 start
\nDescription: Updating global profile registry
\nEstimated time 3 second(s)
\nTask #4 end<\/p>\n

The execution completed successfully.<\/p>\n

For more information see the DB2 installation log at „\/tmp\/db2iupdt.log.6011“.
\nDBI1070I\u00a0 Program db2iupdt completed successfully.<\/p>\n

[root@ol67 instance]# pwd
\n\/opt\/ibm\/db2\/V10.5\/instance
\n[root@ol67 instance]# su – db2inst1
\n[db2inst1@ol67 ~]$ db2val
\nDBI1379I\u00a0 The db2val command is running. This can take several minutes.<\/p>\n

DBI1335I\u00a0 Installation file validation for the DB2 copy installed at
\n\/opt\/ibm\/db2\/V10.5 was successful.<\/p>\n

DBI1339I\u00a0 The instance validation for the instance db2inst1 was
\nsuccessful.<\/p>\n

DBI1343I\u00a0 The db2val command completed successfully. For details, see
\nthe log file \/tmp\/db2val-150823_185427.log.<\/p>\n

[db2inst1@ol67 ~]$
\n[\/crayon]
\nAll done.<\/p>\n

-a-<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

That feeling you have brand new version. Very common setup, after install steps. And surprise!! db2val is yelling „discrepancies found“! \ud83d\ude42<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11],"tags":[],"_links":{"self":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/788"}],"collection":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=788"}],"version-history":[{"count":0,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/788\/revisions"}],"wp:attachment":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=788"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}