SQL1042C An unexpected system error occurred

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MY - 27 Nov 2006 15:29 GMT

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.

Reply to this Message

Phil Sherman - 27 Nov 2006 16:25 GMT

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

> Hi all
>
[quoted text clipped - 6 lines]
> Thanks
> M.

Reply to this Message

MY - 27 Nov 2006 21:03 GMT

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

Thanks

> Did you remember to run the dasupdt command? It should be located in the
> instance directory where you installed db2.
[quoted text clipped - 16 lines]
> > Thanks
> > M.

Reply to this Message

Eric.Jones - 27 Nov 2006 23:36 GMT

> 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

Reply to this Message

MY - 28 Nov 2006 20:25 GMT

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

Thanks

> > I'm getting this error when trying to start and/or stop the admin
> > server on a db2 v9 on AIX 5.3
[quoted text clipped - 6 lines]
>
> Eric

Reply to this Message

Eric.Jones - 29 Nov 2006 20:36 GMT

> 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/developerworks/aix/library/au-dutta_work.html

Eric

Reply to this Message

MY - 29 Nov 2006 21:39 GMT

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

> > My oslevel -r reports 5300-05. I don't know how to check for SPs
>
[quoted text clipped - 9 lines]
>
> Eric

Reply to this Message