DBI1306N when trying to use db2set

Posted by

This was a new one for me, so I thought I’d write up a quick blog entry on it. After creating a new instance and a new database, and even after executing one db2set command successfully, I got this:

>  db2set DB2_CAPTURE_LOCKTIMEOUT=YES

DBI1306N  The instance profile is not defined.

Explanation:

The instance is not defined in the target machine registry.

User response:

Specify an existing instance name or create the required instance.

On googling, I found this technote:
http://www-01.ibm.com/support/docview.wss?uid=swg1IC67080

And to resolve the issue, I ran a db2iupdt (this requires a db2instance outage). First as the db2 instance owner:

> db2stop force
06/27/2012 16:28:45     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
> ipclean
ipclean: Removing DB2 engine and client's IPC resources for db2inst1.
> db2licd -end

Then login as root and do:

> cd /opt/IBM/db2
> cd V9.7
> cd instance
> ./db2iupdt -k -e
db2inst1
DBI1070I  Program db2iupdt completed successfully.


> ./dasupdt
SQL4410W  The DB2 Administration Server is not active.
SQL4406W  The DB2 Administration Server was started successfully.
DBI1070I  Program dasupdt completed successfully.

Then, finally, as db2inst, verify it worked:

> db2start
06/27/2012 16:31:39     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.
> db2set DB2_CAPTURE_LOCKTIMEOUT=YES
> db2set -all
[i] DB2_CAPTURE_LOCKTIMEOUT=YES
[i] DB2_OPT_MAX_TEMP_SIZE=10240 [DB2_WORKLOAD]
[i] DB2_WORKLOAD=WC
[i] DB2_SKIPINSERTED=YES [DB2_WORKLOAD]
[i] DB2_OPTPROFILE=YES [DB2_WORKLOAD]
[i] DB2_USE_ALTERNATE_PAGE_CLEANING=ON
[i] DB2_INLIST_TO_NLJN=YES [O]
[i] DB2_MINIMIZE_LISTPREFETCH=YES [DB2_WORKLOAD]
[i] DB2_REDUCED_OPTIMIZATION=INDEX,UNIQUEINDEX,JOIN,NO_SORT_MGJOIN,JULIE [DB2_WORKLOAD]
[i] DB2_EVALUNCOMMITTED=YES [DB2_WORKLOAD]
[i] DB2_ANTIJOIN=EXTEND [DB2_WORKLOAD]
[i] DB2_SKIPDELETED=YES [DB2_WORKLOAD]
[i] DB2BIDI=ON
[i] DB2COMM=TCPIP
[i] DB2_PARALLEL_IO=*
[g] DB2FCMCOMM=TCPIP4
[g] DB2SYSTEM=redacted
[g] DB2INSTDEF=redacted
[g] DB2ADMINSERVER=redacted

Overall, not a complicated problem

Lead Database Administrator
Ember is always curious and thrives on change. Working in IT provides a lot of that change, but after 18 years developing a top-level expertise on Db2 for mid-range servers and more than 7 years blogging about it, Ember is hungry for new challenges and looks to expand her skill set to the Data Engineering role for Data Science. With in-depth SQL and RDBMS knowledge, Ember shares both posts about her core skill set and her journey into Data Science. Ember lives in Denver and work from home

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.