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. :)
