Today we planned to delete some user accounts from an offline server but by mistake I log into the production server and deleted the accounts there, one of those accounts was the db2inst1 account(the /usr/content/db2home/db2inst1 directory was not deleted) so as soon as I notice the mistake I created the user account(AIX) and assigned the /usr/content/db2home/db2inst1 directory as home.
But when I try to execute db2start just keeps telling...
3 results in 0.0042 seconds.
-
db2 user account deleted accidentally
-
How to Compile Aix C++ Codes in Window platform?
Anyone know how to compile Aix C++ Codes into Window platform?
I have tried to compile my Aix (Version 4.2) C++ Codes using Bloodshed Dev C++ and Microsoft Visual C++ Compiler and I have copied all the include files from my Aix system to my Window system,
but encounter many errors due to the differences in their Library References.
Can anyone help?
Thanks a lot. -
Syscat.triggers valid column
DB2 on AIX. Syscat.triggers have a valid column, and apparently 'N' means the trigger is not valid. How does one set this column to 'Y' or 'N', and if you can set it to 'N', will the trigger fire? I tried the traditional UPDATE sql command to try to change the valid column, but got an error. Is this column purely used internally by DB2, in that valid would only get set to something other than 'Y' if DB2 detected an issue with the trigger?
