 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / December 2005db2start 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- > 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- >> Hey hey all... >> [quoted text clipped - 4 lines] > > 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.  SignatureKnut Stolze DB2 Information Integration Development IBM Germany >>>Hey hey all... >>> [quoted text clipped - 7 lines] > 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 ................ > Well... Nothing that makes sense to me actually... > [quoted text clipped - 11 lines] > 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?) SignatureKnut Stolze DB2 Information Integration Development IBM Germany >>Well... Nothing that makes sense to me actually... >> [quoted text clipped - 18 lines] > 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- >>> Well... Nothing that makes sense to me actually... >>> [quoted text clipped - 28 lines] > > -R- Manually recreated the instance, and it works like a charm... Thanks :) -R- >>>> Well... Nothing that makes sense to me actually... >>>> [quoted text clipped - 33 lines] > > -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 > 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. SignatureKnut Stolze DB2 Information Integration Development IBM Germany >>Should I perhaps recreate the instance with the fixpak installed? >>Is this always needed? [quoted text clipped - 7 lines] > 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- |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.