By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

can't create database cause access failure in db2spcat

P: n/a
Hello!

I set up DB2 Personal Edition on Fedora C4 Linux. During the
Installprocess everything looks fine. But if I try to create a Database
DB2 says: "Routine "db2spcat" (specific name SQL050805133333590) is
implemented with code in library or path "\db2spcat", function
"db2spcat" which cannot be accessed. Reason code:"4". SQLState=42724"

I restarted DAS as dasusr1 and restartet DB2 as db2inst1 - but no luck!
If I try to set up the Sample Databse via First Steps Tool, the Tool
hang up (sleep mode at taskmanager).

Is there someone can help me?

Thanks

Christian Meier

Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Did you check to make sure that it's there? On my system it's at:
...../sqllib/function/unfenced/db2spcat

Assuming that it's there, you might have a permissions problem getting
to it. The files permissions should be -r-xr-xr-x and it should be owned
by user & group bin. The directories leading to it should be owned by
bin with permissions drwxr-xr-x.
Phil Sherman

to*******@freesurf.fr wrote:
Hello!

I set up DB2 Personal Edition on Fedora C4 Linux. During the
Installprocess everything looks fine. But if I try to create a Database
DB2 says: "Routine "db2spcat" (specific name SQL050805133333590) is
implemented with code in library or path "\db2spcat", function
"db2spcat" which cannot be accessed. Reason code:"4". SQLState=42724"

I restarted DAS as dasusr1 and restartet DB2 as db2inst1 - but no luck!
If I try to set up the Sample Databse via First Steps Tool, the Tool
hang up (sleep mode at taskmanager).

Is there someone can help me?

Thanks

Christian Meier

Nov 12 '05 #2

P: n/a
ok, the File is there - just for to go sure
locate db2spcat
/home/db2inst1/sqllib/function/unfenced/db2spcat
/opt/IBM/V8.1/function/unfenced/db2spcat
/opt/IBM/V8.1/bnd/db2spcat.bnd
-----
/home/db2inst1/sqllib/function/unfenced/db2spcat
-> file premission is lrwxrwxrwx - might not be a problem
folders are owned by bin

/opt/IBM/V8.1/function/unfenced/db2spcat
-> all premissions as you discribed but opt, IBM, V8.1 Folder are
owned by root and function, unfenced are ownded by bin.

any other suggestions?

Nov 12 '05 #3

P: n/a
to*******@freesurf.fr wrote:
-----
/home/db2inst1/sqllib/function/unfenced/db2spcat
-> file premission is lrwxrwxrwx - might not be a problem
folders are owned by bin


the l in the persmissions mean it's a symlink.
check the location of this link. (dead link doesn't work, no matter the
permissions :))
Furthermore, link permissions != file permissions. (on some systems that
is) so check the link target for the permissions.
(target can be found by performing an ls -l on the link)

-R-
Nov 12 '05 #4

P: n/a

Jurgen Haan schrieb:
to*******@freesurf.fr wrote:
-----
/home/db2inst1/sqllib/function/unfenced/db2spcat
-> file premission is lrwxrwxrwx - might not be a problem
folders are owned by bin


the l in the persmissions mean it's a symlink.
check the location of this link. (dead link doesn't work, no matter the
permissions :))
Furthermore, link permissions != file permissions. (on some systems that
is) so check the link target for the permissions.
(target can be found by performing an ls -l on the link)

-R-


ah ok - I am new to Linux, so lets do it:
lrwxrwxrwx 1 root db2grp1 44 4. Aug 19:21 db2spcat ->
/opt/IBM/db2/V8.1/function/unfenced/db2spcat

and the linked Target
-rwxrwxrwx 1 bin bin 0 5. Aug 15:53 db2spcat

What can I do ... the premissions should not be the problem

Nov 12 '05 #5

P: n/a
could it be a Kernel problem cause IBMs site says the recommended
Kernel is 2.4 and Fedora C4s Kernel is 2.6??

Nov 12 '05 #6

P: n/a

<to*******@freesurf.fr> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

Jurgen Haan schrieb:
to*******@freesurf.fr wrote:
-----
/home/db2inst1/sqllib/function/unfenced/db2spcat
-> file premission is lrwxrwxrwx - might not be a problem
folders are owned by bin


the l in the persmissions mean it's a symlink.
check the location of this link. (dead link doesn't work, no matter the
permissions :))
Furthermore, link permissions != file permissions. (on some systems that
is) so check the link target for the permissions.
(target can be found by performing an ls -l on the link)

-R-


ah ok - I am new to Linux, so lets do it:
lrwxrwxrwx 1 root db2grp1 44 4. Aug 19:21 db2spcat ->
/opt/IBM/db2/V8.1/function/unfenced/db2spcat

and the linked Target
-rwxrwxrwx 1 bin bin 0 5. Aug 15:53 db2spcat


I think the problem is that the file is 0 bytes. Even if the permissions
are correct, DB2 will have a tough time loading and using what should be in
this file :)

Do you have enough space on /opt ? I'm guessing that your filesystem is
full and DB2 was not able to properly install some of its files.

--
Matt Emmerton
Nov 12 '05 #7

P: n/a
arrrrggg ... i didn't see the file size!
thank you it might be a space problem ... going to check it out.

thanks!
Christian Meier

Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.