Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 11:39 AM
_link98@yahoo.com
Guest
 
Posts: n/a
Default db2start fails on Solaris 8.2 (SQL1042C)


New installation of DB2 ESE 8.1 and Fixpak 9a on
Solaris 8.2, on FUJITSU 450 server(sparc), 64 bit mode, and 64-bit
instance.

db2start fails (after approx 60 seconds) with SQL1042C (unexpected
system error occurred), so the instance does not start.

db2diag.log shows a timeout error. sqloWaitIPCWaitPost.
ENOMSG(35) no message of desired type.

db2trc shows SQLO_SEM_TIMEOUT.

Any suggestions? (PMR already opened, just checking if someone already
saw this and found a workaround).

The db2 Pre-reqs for Solaris 8.2 are in place (patch levels as per IBM
website solaris_prereq.pdf document) and kernel parameters changed to
those recommended for machines with more than 16gig of RAM (msginfo_*,
seminfo_*, shminfo_* ).

  #2  
Old November 12th, 2005, 11:39 AM
Larry
Guest
 
Posts: n/a
Default Re: db2start fails on Solaris 8.2 (SQL1042C)

Did you do a db2iupdt after application of the fp?

Larry Edelstein

_link98@yahoo.com wrote:[color=blue]
> New installation of DB2 ESE 8.1 and Fixpak 9a on
> Solaris 8.2, on FUJITSU 450 server(sparc), 64 bit mode, and 64-bit
> instance.
>
> db2start fails (after approx 60 seconds) with SQL1042C (unexpected
> system error occurred), so the instance does not start.
>
> db2diag.log shows a timeout error. sqloWaitIPCWaitPost.
> ENOMSG(35) no message of desired type.
>
> db2trc shows SQLO_SEM_TIMEOUT.
>
> Any suggestions? (PMR already opened, just checking if someone already
> saw this and found a workaround).
>
> The db2 Pre-reqs for Solaris 8.2 are in place (patch levels as per IBM
> website solaris_prereq.pdf document) and kernel parameters changed to
> those recommended for machines with more than 16gig of RAM (msginfo_*,
> seminfo_*, shminfo_* ).
>[/color]
  #3  
Old November 12th, 2005, 11:39 AM
_link98@yahoo.com
Guest
 
Posts: n/a
Default Re: db2start fails on Solaris 8.2 (SQL1042C)

Larry wrote:[color=blue]
> Did you do a db2iupdt after application of the fp?
>
> Larry Edelstein[/color]

No, I could not, because there was no instance to update.

The installation was a response-file-installation that
did the base installation (V8.1) and then applied FP9a.

Prior to the installation there was no DB2 on the box,
and the base installation did not create any instances.

Only after installation of base+fp9a completed without
error did I manually create the instance+DAS server
without any problems. It is at this point that the
db2start fails (after configuring SVCENAME first).

Any other suggestion?

  #4  
Old November 12th, 2005, 11:41 AM
_link98@yahoo.com
Guest
 
Posts: n/a
Default Re: db2start fails on Solaris 8.2 (SQL1042C)

Solved: applied a set of Solaris 8.2 patches (different
from those specified on the IBM websites). Dropped instance,
Uninstalled
and re-installed, manually created instance, and it works fine now.



_link98@yahoo.com wrote:[color=blue]
> New installation of DB2 ESE 8.1 and Fixpak 9a on
> Solaris 8.2, on FUJITSU 450 server(sparc), 64 bit mode, and 64-bit
> instance.
>
> db2start fails (after approx 60 seconds) with SQL1042C (unexpected
> system error occurred), so the instance does not start.
>
> db2diag.log shows a timeout error. sqloWaitIPCWaitPost.
> ENOMSG(35) no message of desired type.
>
> db2trc shows SQLO_SEM_TIMEOUT.
>
> Any suggestions? (PMR already opened, just checking if someone already
> saw this and found a workaround).
>
> The db2 Pre-reqs for Solaris 8.2 are in place (patch levels as per IBM
> website solaris_prereq.pdf document) and kernel parameters changed to
> those recommended for machines with more than 16gig of RAM (msginfo_*,
> seminfo_*, shminfo_* ).[/color]

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,164 network members.