Showing posts with label DB2. Show all posts
Showing posts with label DB2. Show all posts

Monday, November 27, 2006

Configuring DB2 V8.2 for local usage...but logging in with...

It was snowing heavily last night here at Vancouver. I had a feeling last night that I would stay at home working today. This morning I tried to drive to the main road (which should be safe for the people who do not have 4X4), but after several attempts I quitted. I then stayed at home and continued on my work at 7:30 am in the morning!

Later in the afternoon I needed to install DB2 V8.2 to my laptop. I just installed from a DVD which is a PE. After the software installation I just got stuck in the fixpack installation. After several rounds of investigation, thank God that finally I got the thing solved. It's so funny that I somehow realized it should be a bug in the fixpack installer.

After that I am ready to create my database. However, I got a SQL1092N error!

SQL1092N "DAIPOK" does not have the authority to perform the requested.

I was like full of question marks, and began to go back to the fundamentals. I checked that I was in the group of DB2ADMNS already. I then began my several rounds of googling, and nothing interesting and relevant returned !

I started to figure out that the id that I put to DB2ADMNS was actually my LOCAL id. I logged off from my domain, and logged in as local. I could create a database no problem. However, if I wanted to create a database when I logged onto the domain, I got that scary error again. I figured out that my database creation should only need to be done one time, so I decided to log on as local to create it. My stupidity as a drilling I.T. Specialist told me not to avoid the problem, but faced it with pride. I spent an hour doing some research on the web, and came across this article written by an IBMer:

How To Develope DB2 Application on an airplane


Man! This article rocks! Don't get into the detail (if you are busy) but just scroll way down to the bottom:

db2set DB2_GRP_LOOKUP=LOCAL,TOKENLOCAL

You can also do it through IBM DB2->Set-up Tools->Configuration Assistant->DB2 Registry.

Kudos to Leon! However, I want to suggest him to change the blog title. The title misled me to think he's creating a database application for an airplane -__-". May be it's just my English problem. :)