473,387 Members | 1,700 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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_* ).

Nov 12 '05 #1
3 3095
Did you do a db2iupdt after application of the fp?

Larry Edelstein

_l*****@yahoo.com wrote:
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_* ).

Nov 12 '05 #2
Larry wrote:
Did you do a db2iupdt after application of the fp?

Larry Edelstein


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?

Nov 12 '05 #3
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.

_l*****@yahoo.com wrote:
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_* ).


Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: jim.brown | last post by:
The attached code implements a test class to show an error in overloading operator=. This code works on Windows with Visual Studio and simpler cases work with gcc 3.3.2 on Solaris 9. On Windows,...
3
by: Robert Kane | last post by:
Good afternoon, I'm trying to set up a clustered DB2 v7.1 database on Redhat Linux 7.3. I've followed the instructions (as far as I know) in the accompanying documentation to set up the database...
2
by: Kumar | last post by:
Need urgent help... I have installed DB2UDB version 7.2 on Windows 2000. When I try to open Command center or Command window it gives me the following error:...
0
by: apattin | last post by:
Hi all, We've recently installed a network drive that works fine (you can copy data in/out). I am trying to create a database on it; the database server is in another PC (Windows 2K, DB2 8.1)....
9
by: Jurgen Haan | last post by:
Hey hey all... I'm in the following situation: I installed SuSE SLES9 on a dual core Opteron 275 (proliant DL385). 2GB Mem, hardware raid. I performed an install of DB2 for X86_64 8.2 FP 1...
1
by: Ranjay | last post by:
i've installed db2 on my aix box with the following configuration bash-3.00$ uname -a -v -r AIX symibm10 2 5 00CE60AA4C00 bash-3.00$ oslevel 5.2.0.0 I installed it in the compact mode and...
1
by: DianaB | last post by:
Hello, I tried to do the catalog local node command to catalog a node from one instance to another. i.e. I ran the command db2 catalog local node REPORTDB intance reportdb The command...
0
by: Phil Sherman | last post by:
This occurred in a non-supported UDB environment. I am providing it as "gotcha" information. SQL1084C error was received when attempting the first connect to the (formerly working) SAMPLE...
8
by: hveillette | last post by:
Hi everybody, I have a very strange problem with one DB (only one in a list of 21). This DB is used by a Java application and work fine since a couple of years. This week the application stop...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.