473,324 Members | 1,678 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,324 software developers and data experts.

db2start gives an error after DB2 installation

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 (8.1 FP 8)
Install went ok, status log says success on every action taken.
rights are ok, users are ok, etc.
I immediatly upgrade to X86_64 8.2 FP 3 (8.1 FP 10)
Completes just fine, no errors whatsoever.

After upgrading I create /etc/sysctl.conf containing
# Added for 64-bit DB2
kernel.sem=250 32000 32 1024
kernel.msgmni=1024
kernel.shmmni=65536
kernel.shmmax=1073741824
#end additions for DB2

and run sysctl -p /etc/sysctl.conf and place this line in the bootscripts.

When I execute db2start as the db2inst user (default instance) I get:
"SQL1042C An unexpected system error occurred. SQLSTATE=58004"

Can't figure out what's the cause of this... dragged db2start through a
strace, nothing strange happens. ldd says all libraries are ok and I can
invoke the CLI without problems...
The only thing I cannot do, is start DB2 :P

Does anyone have any ideas on what may be the cause of this happening?

Thanks.

-R-
Dec 7 '05 #1
9 4711
Jurgen Haan wrote:
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.


Needless to say, but the SuSE install is also 64 bit

-R-
Dec 7 '05 #2
Jurgen Haan wrote:
Jurgen Haan wrote:
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.


Needless to say, but the SuSE install is also 64 bit


Have a look at your instance's sqllib/db2dump/db2diag.log file. There
should be some more information in there.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Dec 7 '05 #3
Knut Stolze wrote:
Jurgen Haan wrote:

Jurgen Haan wrote:
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.


Needless to say, but the SuSE install is also 64 bit

Have a look at your instance's sqllib/db2dump/db2diag.log file. There
should be some more information in there.


Well... Nothing that makes sense to me actually...

2005-12-07-10.43.15.941124+000 I42046E1632 LEVEL: Event
PID : 7322 TID : 182968220384PROC : db2start
INSTANCE: db2inst NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 33 bytes
/home/db2inst/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x0000007FBFFFACE0 : 2F68 6F6D 652F 6462 3269 6E73 742F 7371
/home/db2inst/sq
0x0000007FBFFFACF0 : 6C6C 6962 2F61 646D 2F64 6232 7374 6172
llib/adm/db2star
0x0000007FBFFFAD00 : 3200 0000 0000 0000 0000 0000 0000 0000
2...............
0x0000007FBFFFAD10 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFAD20 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFAD30 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFAD40 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFAD50 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFAD60 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFAD70 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFAD80 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFAD90 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFADA0 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFADB0 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFADC0 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x0000007FBFFFADD0 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
Dec 7 '05 #4
Jurgen Haan wrote:
Well... Nothing that makes sense to me actually...

2005-12-07-10.43.15.941124+000 I42046E1632 LEVEL: Event
PID : 7322 TID : 182968220384PROC : db2start
INSTANCE: db2inst NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 33 bytes
/home/db2inst/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x0000007FBFFFACE0 : 2F68 6F6D 652F 6462 3269 6E73 742F 7371
/home/db2inst/sq
0x0000007FBFFFACF0 : 6C6C 6962 2F61 646D 2F64 6232 7374 6172
llib/adm/db2star
0x0000007FBFFFAD00 : 3200 0000 0000 0000 0000 0000 0000 0000
2...............


This just says that "db2star2" is invoked with the options
"/home/db2inst/sqllib/adm/db2star2". This looks quite fine as far as it
goes.

Stupid question, maybe: you did update your instange after you applied the
FP? (Or when did you create the instance in the whole process?)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Dec 7 '05 #5
Knut Stolze wrote:
Jurgen Haan wrote:

Well... Nothing that makes sense to me actually...

2005-12-07-10.43.15.941124+000 I42046E1632 LEVEL: Event
PID : 7322 TID : 182968220384PROC : db2start
INSTANCE: db2inst NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 33 bytes
/home/db2inst/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x0000007FBFFFACE0 : 2F68 6F6D 652F 6462 3269 6E73 742F 7371
/home/db2inst/sq
0x0000007FBFFFACF0 : 6C6C 6962 2F61 646D 2F64 6232 7374 6172
llib/adm/db2star
0x0000007FBFFFAD00 : 3200 0000 0000 0000 0000 0000 0000 0000
2...............

This just says that "db2star2" is invoked with the options
"/home/db2inst/sqllib/adm/db2star2". This looks quite fine as far as it
goes.

Stupid question, maybe: you did update your instange after you applied the
FP? (Or when did you create the instance in the whole process?)


Hmmm.. during the initial install...

Should I perhaps recreate the instance with the fixpak installed?
Is this always needed?
It's not actually in the spirit of updating, is it? :)

-R-
Dec 7 '05 #6
Jurgen Haan wrote:
Knut Stolze wrote:
Jurgen Haan wrote:

Well... Nothing that makes sense to me actually...

2005-12-07-10.43.15.941124+000 I42046E1632 LEVEL: Event
PID : 7322 TID : 182968220384PROC : db2start
INSTANCE: db2inst NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode,
probe:1130
DATA #1 : String, 33 bytes
/home/db2inst/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x0000007FBFFFACE0 : 2F68 6F6D 652F 6462 3269 6E73 742F 7371
/home/db2inst/sq
0x0000007FBFFFACF0 : 6C6C 6962 2F61 646D 2F64 6232 7374 6172
llib/adm/db2star
0x0000007FBFFFAD00 : 3200 0000 0000 0000 0000 0000 0000 0000
2...............


This just says that "db2star2" is invoked with the options
"/home/db2inst/sqllib/adm/db2star2". This looks quite fine as far as it
goes.

Stupid question, maybe: you did update your instange after you applied
the
FP? (Or when did you create the instance in the whole process?)


Hmmm.. during the initial install...

Should I perhaps recreate the instance with the fixpak installed?
Is this always needed?
It's not actually in the spirit of updating, is it? :)

-R-


Manually recreated the instance, and it works like a charm...
Thanks :)

-R-
Dec 7 '05 #7
Jurgen Haan wrote:
Should I perhaps recreate the instance with the fixpak installed?
Is this always needed?


No, you just can run the "db2iupdt" command. You'll find it here:

/opt/IBM/db2/V8.1/instance/db2iupdt

The reason why you must update the instance is simply that a few files and
executables reside as a _copy_ in the instance's directory. If you install
a new FP, only the system-wide files are updated, and you have to ensure
that the copies pick up any changes as well.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Dec 7 '05 #8
Jurgen Haan wrote:
Jurgen Haan wrote:
Knut Stolze wrote:
Jurgen Haan wrote:
Well... Nothing that makes sense to me actually...

2005-12-07-10.43.15.941124+000 I42046E1632 LEVEL: Event
PID : 7322 TID : 182968220384PROC : db2start
INSTANCE: db2inst NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode,
probe:1130
DATA #1 : String, 33 bytes
/home/db2inst/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x0000007FBFFFACE0 : 2F68 6F6D 652F 6462 3269 6E73 742F 7371
/home/db2inst/sq
0x0000007FBFFFACF0 : 6C6C 6962 2F61 646D 2F64 6232 7374 6172
llib/adm/db2star
0x0000007FBFFFAD00 : 3200 0000 0000 0000 0000 0000 0000 0000
2...............


This just says that "db2star2" is invoked with the options
"/home/db2inst/sqllib/adm/db2star2". This looks quite fine as far as it
goes.

Stupid question, maybe: you did update your instange after you
applied the
FP? (Or when did you create the instance in the whole process?)


Hmmm.. during the initial install...

Should I perhaps recreate the instance with the fixpak installed?
Is this always needed?
It's not actually in the spirit of updating, is it? :)

-R-

Manually recreated the instance, and it works like a charm...
Thanks :)

-R-

You don't need to recreate the instance after a fixpak install, you just
need to update it. See the fixpak readme instructions.

Larry Edelstein
Dec 7 '05 #9
Knut Stolze wrote:
Jurgen Haan wrote:

Should I perhaps recreate the instance with the fixpak installed?
Is this always needed?

No, you just can run the "db2iupdt" command. You'll find it here:

/opt/IBM/db2/V8.1/instance/db2iupdt

The reason why you must update the instance is simply that a few files and
executables reside as a _copy_ in the instance's directory. If you install
a new FP, only the system-wide files are updated, and you have to ensure
that the copies pick up any changes as well.


Lol... sorry for the ignorance...

I never updated a DB2 install before...
Most were test databases which never lasted long enough to need an update :)

Thanks for the info people.

-R-
Dec 7 '05 #10

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

Similar topics

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...
1
by: Jean-Marc Blaise | last post by:
Dear all, I have applied on Linux the FP7 for DB2 UDB V8.1. Then I have installed the FP7 information center. db2start: error while loading shared librairies: libcxa.so.1... This library...
3
by: _link98 | last post by:
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...
9
by: ghumman | last post by:
running on windows, I encounter following db2start. SQL6030N START or STOP DATABASE MANAGER failed. Reason code "13". any ideas why db2start is failing ?
8
by: | last post by:
Wel, I am rebuilding the VC# 2002 project that I have deployment problems with the 2003 version, hoping this solves the problems, but now I encounter this wierd bug??? If I have the project, and...
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...
2
by: LittleMaster | last post by:
Dear Gurus Please help. I have installed DB2 8.2 on AIX 5.3. No apparent errors while installing. I opted the defaults to create the instance db2inst1 But when I do a db2start, I get the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.