Chaps,
I'm having a small problem installing db2 on a Red Hat Enterprise
server (version 4)
Basically I installed DB2 V8.1 , applied fixpak 5 and then the 2.6
kernel specific fixpak 9 update. I then created the the administration
instance and some "user" instances
db2admin start works just fine but whenever I try and run db2start in
one of the "user" instances I get an SQL1024C error message.
Looking in sqllib\db2dump directory, the db2diag.log file has the
following contents. It looks like its the
############### ##
2005-06-16-08.47.25.783822 +060 I2717G410 LEVEL: Severe
PID : 3642 TID : 3086911168 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrast ructure, sqlerInitFmpHea p, probe:25
RETCODE : ZRC=0x800F0067=-2146500505=SQLO _ID_2LONG
"USERID/GROUPID is greater than the Shelby Supported
size/length"
DIA8111C Authorization failure.
############### ##
that's the problem.
Can anyone help?
Alex
dbdiag.log contents:-
2005-06-16-08.47.25.305262 +060 I1G1209 LEVEL: Event
PID : 3638 TID : 3086911168 PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, _pdlogInt, probe:120
START : New db2diag.log file
DATA #1 : Build Level, 124 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022"
with level identifier "03030106".
Informational tokens are "DB2 v8.1.2.88", "s050422", "MI00117", FixPak
"9".
DATA #2 : System Info, 364 bytes
System: Linux schubert 6 2 i686
CPU: total:2 online:2
Physical Memory(MB): total:2026 free:1662
Virtual Memory(MB): total:6027 free:5663
Swap Memory(MB): total:4001 free:4001
Kernel Params: msgMaxMessageSi ze:8192 msgMsgMap:16384
msgMaxQueueIDs: 1024
msgNumberOfHead ers:16384 msgMaxQueueSize :16384
msgMaxSegmentSi ze:16 shmMax:26843545 6 shmMin:1
shmIDs:4096
shmSegments:409 6 semMap:32000 semIDs:1024 semNum:32000
semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit :32767
Information in this record is only valid at the time when this file was
created (see this record's time stamp)
2005-06-16-08.47.25.304813 +060 I1211G1505 LEVEL: Event
PID : 3638 TID : 3086911168 PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSi ngleNode,
probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0xBFE73654 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73
/home/db2inst1/s
0xBFE73664 : 716C 6C69 622F 6164 6D2F 6462 3273 7461
qllib/adm/db2sta
0xBFE73674 : 7232 0000 0000 0000 0000 0000 0000 0000
r2............. .
0xBFE73684 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE73694 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE736A4 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE736B4 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE736C4 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE736D4 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE736E4 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE736F4 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE73704 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE73714 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE73724 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE73734 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0xBFE73744 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
2005-06-16-08.47.25.783822 +060 I2717G410 LEVEL: Severe
PID : 3642 TID : 3086911168 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrast ructure, sqlerInitFmpHea p, probe:25
RETCODE : ZRC=0x800F0067=-2146500505=SQLO _ID_2LONG
"USERID/GROUPID is greater than the Shelby Supported
size/length"
DIA8111C Authorization failure.
2005-06-16-08.47.25.800945 +060 I3128G346 LEVEL: Severe
PID : 3642 TID : 3086911168 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloRunInstance , probe:160
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFE696E4 : EEFB FFFF ....
2005-06-16-08.47.25.801200 +060 I3475G336 LEVEL: Severe
PID : 3642 TID : 3086911168 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:115
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFE69744 : EEFB FFFF .... 4 3923
I'd take a look at the group that the instance owner(s) belong to. Since
"db2inst1", the instance owner is only 8 characters (and works fine on
my RHEL4 fp9 setup; the group name is the likely suspect. In the Windows
environment; it's limited to 8 or less characters. I didn't find any
reference to a limit on linux but I'd try 8 or less there too.
*** SOAPBOX ON ***
As usual; the error message shown in the first "RETCODE:" states what is
wrong without specifying exactly what is valid. How much additional work
would it have been to display the "Supported size/length"?
*** SOAPBOX OFF ***
Phil Sherman
alexs wrote: Chaps,
I'm having a small problem installing db2 on a Red Hat Enterprise server (version 4) Basically I installed DB2 V8.1 , applied fixpak 5 and then the 2.6 kernel specific fixpak 9 update. I then created the the administration instance and some "user" instances
db2admin start works just fine but whenever I try and run db2start in one of the "user" instances I get an SQL1024C error message.
Looking in sqllib\db2dump directory, the db2diag.log file has the following contents. It looks like its the
############### ## 2005-06-16-08.47.25.783822 +060 I2717G410 LEVEL: Severe PID : 3642 TID : 3086911168 PROC : db2wdog INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, routine_infrast ructure, sqlerInitFmpHea p, probe:25 RETCODE : ZRC=0x800F0067=-2146500505=SQLO _ID_2LONG "USERID/GROUPID is greater than the Shelby Supported size/length" DIA8111C Authorization failure. ############### ## that's the problem.
Can anyone help? Alex
dbdiag.log contents:-
2005-06-16-08.47.25.305262 +060 I1G1209 LEVEL: Event PID : 3638 TID : 3086911168 PROC : db2start INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, RAS/PD component, _pdlogInt, probe:120 START : New db2diag.log file DATA #1 : Build Level, 124 bytes Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022" with level identifier "03030106". Informational tokens are "DB2 v8.1.2.88", "s050422", "MI00117", FixPak "9". DATA #2 : System Info, 364 bytes System: Linux schubert 6 2 i686 CPU: total:2 online:2 Physical Memory(MB): total:2026 free:1662 Virtual Memory(MB): total:6027 free:5663 Swap Memory(MB): total:4001 free:4001 Kernel Params: msgMaxMessageSi ze:8192 msgMsgMap:16384 msgMaxQueueIDs: 1024 msgNumberOfHead ers:16384 msgMaxQueueSize :16384 msgMaxSegmentSi ze:16 shmMax:26843545 6 shmMin:1 shmIDs:4096 shmSegments:409 6 semMap:32000 semIDs:1024 semNum:32000 semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20 semMaxVal:32767 semAdjustOnExit :32767 Information in this record is only valid at the time when this file was created (see this record's time stamp)
2005-06-16-08.47.25.304813 +060 I1211G1505 LEVEL: Event PID : 3638 TID : 3086911168 PROC : db2start INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSi ngleNode, probe:1130 DATA #1 : String, 34 bytes /home/db2inst1/sqllib/adm/db2star2 DATA #2 : Hexdump, 256 bytes 0xBFE73654 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s 0xBFE73664 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta 0xBFE73674 : 7232 0000 0000 0000 0000 0000 0000 0000 r2............. . 0xBFE73684 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE73694 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE736A4 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE736B4 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE736C4 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE736D4 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE736E4 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE736F4 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE73704 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE73714 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE73724 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE73734 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0xBFE73744 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
2005-06-16-08.47.25.783822 +060 I2717G410 LEVEL: Severe PID : 3642 TID : 3086911168 PROC : db2wdog INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, routine_infrast ructure, sqlerInitFmpHea p, probe:25 RETCODE : ZRC=0x800F0067=-2146500505=SQLO _ID_2LONG "USERID/GROUPID is greater than the Shelby Supported size/length" DIA8111C Authorization failure.
2005-06-16-08.47.25.800945 +060 I3128G346 LEVEL: Severe PID : 3642 TID : 3086911168 PROC : db2wdog INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, oper system services, sqloRunInstance , probe:160 MESSAGE : DiagData DATA #1 : Hexdump, 4 bytes 0xBFE696E4 : EEFB FFFF ....
2005-06-16-08.47.25.801200 +060 I3475G336 LEVEL: Severe PID : 3642 TID : 3086911168 PROC : db2wdog INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:115 MESSAGE : DiagData DATA #1 : Hexdump, 4 bytes 0xBFE69744 : EEFB FFFF ....
Nope, all the instances have the same group name as the userid, with
the group names being members of the db2admin group as defined in
/etc/groups.
well,
checked allthe userid and group id stuff seemed o.k.
Did a chown db2inst1.db2ins t1 db2inst1 in the home directory just to
make sure everything was owned by the instance deleted everything in
/tmp ... and it worked. Repeated the process for the other instances
I'd created and it sprang into life
alexs wrote: Nope, all the instances have the same group name as the userid, with the group names being members of the db2admin group as defined in /etc/groups.
alexs wrote: well, checked allthe userid and group id stuff seemed o.k.
Did a chown db2inst1.db2ins t1 db2inst1 in the home directory just to make sure everything was owned by the instance deleted everything in /tmp ... and it worked. Repeated the process for the other instances I'd created and it sprang into life
Ugh, that's asking for trouble. Some of the files under the sqllib
directory should NOT be owned by the instance owner. If you suspect
ownership/permissions are incorrect, you should shut down the
instance and use 'db2iupdt'. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jean-Christian Imbeault |
last post by:
I have a user account on a RH Linux machine but no root access.
I succesfully installed apache 1.3 under my /home/ account but can't
get PHP to install properly.
I have done the following steps:
#1 compiled and installed apache using --prefix=/home/imbeauje/apache.
Tested that it works.
|
by: oliversl |
last post by:
Hi,
I have a stock RHEL4 server and not that the imap_open() function no
longer
works.
I have a local pop3 server running dovecot that I use to autenticate
with this line:
$imap_stream =
imap_open("{mailserver:995/pop3/notls/ssl/novalidate-cert}", $username,
$password, OP_HALFOPEN);
|
by: Steve |
last post by:
I'm posting this message here, so that someone googling here will be
able to find it.
I was having problems installing cx_Oracle on Solaris. The build would
fail with a message:
> ld: fatal: file /apps/oracle/prod/9.2/lib/libclntsh.so: wrong ELF class: ELFCLASS64
I found the solution on Grig Gheorghiu's blog. Grig had similar
problems when installing on UNIX, specifically AIX. You can find his
|
by: jaggi |
last post by:
Hi all,
I downloaded DB2 enterprise edition from partnerworld on ibm.com and
unzipped and untarred it and copied it to CD and tried installing on AIX
using SMIT.
I am getting errors while installing DB2. they seems like related to java or
dependent on java. Is there anyone who has faced some problem installing
DB2? Do i have to install Java from expansion pack or bonus pack before
installing DB2
regards,
|
by: bjhartin |
last post by:
All,
I was working at a client's site when I installed Visual Basic 6 on a
machine at their request. Existing applications on this machine had
specified version 4.0 of the Jet OLEDB provider in a data source string
in their config files. After installing VB 6, they stopped working,
producing the error "3220: The supplied provider is different from the
one already in use. Changing their configuration files to specify
version 3.5.1...
| |
by: Adam |
last post by:
Im trying to add an httphandler for all *.sgf file extensions. I have
developed the handler,
1. installed it into the gac
2. added it to the machine.config:
<httpHandlers>
<add verb="*" path="*.sgf" type="CustomExtensionHandler,
Extenders.CustomExtensionHandler, Version=1.0.0.0, Culture=neutral,
PublicKeyToken=d831d925597c1031" validate="True"/>
</httpHandlers>
|
by: Reestit Mutton |
last post by:
I'm trying to get the mysqli object-oriented syntax to work in php. I
understand that I have to have at least version 5 of php - I've
therefore opted for version 5.1.4. The remainder of my setup is as follows
php 5.1.4
mysql 4.1.10a-2.RHEL4.1
httpd-2.0.52-12.2.ent
Redhat Enterprise Linux 4
To be able to configure and compile the source of php to work with
|
by: girish574 |
last post by:
After the integration of boost serialization code, the exceptions
are not at all getting caught in my application. Im building on RHEL4
kernel 2.6.9-42.ELsmp and gcc version is 4.0.2. The application
terminates when exception is thrown. Removing the serialization code
makes the exceptions getting caught.
The worst part is im not able to reproduce the scenario in a small
program.
|
by: Eric B. |
last post by:
Hi,
I appologize if this is slightly OT, but I am really struggling to figure
out how to install Python2.4 on RHEL4. To make matters worse, the RHEL4
machine is a 64bit architecture.
I search pyvault, but they only have for .i386. Does anyone know where /
how I can find Python2.4 for RHEL4 x64?
If there is a better place to be asking this question, please let me know,
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |