SQL1042C An unexpected system error occurred

[MY]

Hi all

I'm getting this error when trying to start and/or stop the admin
server on a db2 v9 on AIX 5.3
Everything worked fine with v8.2. I did the upgrade by the book.

any tips would be appreciated.

Thanks
M.

[Phil Sherman]

Did you remember to run the dasupdt command? It should be located in the
instance directory where you installed db2.

Don't forget that you also need to run the admin instance owner's
db2profile command to setup your environment. The userid you're using to
start the admin server must be recognized by db2 as one allowed to issue
the command.

Phil Sherman

MY wrote:

Hi all

I'm getting this error when trying to start and/or stop the admin
server on a db2 v9 on AIX 5.3
Everything worked fine with v8.2. I did the upgrade by the book.

any tips would be appreciated.

Thanks
M.

[MY]

Yes. I even deleted the das and re-created it. Still didn't work.

Thanks
On Nov 27, 11:25 am, Phil Sherman <[e-mail]:

Did you remember to run the dasupdt command? It should be located in the
instance directory where you installed db2.

Don't forget that you also need to run the admin instance owner's
db2profile command to setup your environment. The userid you're using to
start the admin server must be recognized by db2 as one allowed to issue
the command.

Phil Sherman

MY wrote:

Hi all

I'm getting this error when trying to start and/or stop the admin
server on a db2 v9 on AIX 5.3
Everything worked fine with v8.2. I did the upgrade by the book.

any tips would be appreciated.

Thanks
M.

[Eric.Jones]

MY wrote:

>
I'm getting this error when trying to start and/or stop the admin
server on a db2 v9 on AIX 5.3
Everything worked fine with v8.2. I did the upgrade by the book.

This sounds like IY89861 behavior;
are you running AIX 5.3.0 TL05 with SP1 or SP2 perhaps?

The "Known issues for DB2 on AIX" support page has more info,
including links to an efix package. But the final fix is now
included in the AIX TL05-SP3 release.
Eric

[MY]

My oslevel -r reports 5300-05. I don't know how to check for SPs

Thanks
On Nov 27, 6:37 pm, "Eric.Jones" <[e-mail]:

MY wrote:

I'm getting this error when trying to start and/or stop the admin
server on a db2 v9 on AIX 5.3
Everything worked fine with v8.2. I did the upgrade by the book.This sounds like IY89861 behavior;

are you running AIX 5.3.0 TL05 with SP1 or SP2 perhaps?

The "Known issues for DB2 on AIX" support page has more info,
including links to an efix package. But the final fix is now
included in the AIX TL05-SP3 release.

Eric

[Eric.Jones]

MY wrote:

My oslevel -r reports 5300-05. I don't know how to check for SPs

Thanks

IBM has added another option to oslevel: -s (show SP?)

>oslevel -s

5300-05-03 (which means: AIX 5.3 TL05 SP3)

The DeveloperWorks article on AIX was updated to include
the new commands and terminology:

http://www-128.ibm.com/developerwork...utta_work.html
Eric

[MY]

Thanks for all the tips. I'll concentrate my efforts on getting SP3
(i'm at now)

On Nov 29, 3:37 pm, "Eric.Jones" <[e-mail]:

MY wrote:

My oslevel -r reports 5300-05. I don't know how to check for SPs

ThanksIBM has added another option to oslevel: -s (show SP?)

>oslevel -s

5300-05-03 (which means: AIX 5.3 TL05 SP3)

The DeveloperWorks article on AIX was updated to include
the new commands and terminology:

http://www-128.ibm.com/developerwork...utta_work.html

Eric