Hi Kevin,
Check the directory permissions of $HOME/sqllib/sqldbdir
One of our systems shows:
drwxrwsr-x 2 userid sysadgrp 512 Jul 24 1999 sqldbdir
Most of the sqllib subdirectories have the set group id bit
set for the group, owner read/write/exec, group read/write/setgroupid,
world read/execute.
I would guess your users might be running into the lack of execute
for world, so the directory cannot be accessed.
If you need a complete listing of all files & directories in sqllib,
let me know.
Good luck & HTH.
Regards,
Scott
Do you want to just monitor your database, or do you actually want it
to go orders of magnitude faster? Breakthrough results for DB2:
http://www.database-guys.com/story.shtml
----- Original Message -----
From: Huls, Kevin <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 19, 2001 5:04 PM
Subject: DB2EUG: File permissions mishap
>
>
> Our UNIX Sys Admin inadvertantly
> did a recursive chmod that caused numerous files and directories
> to have permissions of r--r--r-- . They believe that the original
> permissions
> have been restored including setuid and setgid permissions.
>
> However users are still getting an error:
>
>
> db2 => describe table jt.tow_name_adrs
> SQL1031N The database directory cannot be found on the indicated file
> system.
> SQLSTATE=58031
>
> Does anyone know how this can be corrected?
>
>
> Thanks in advance,
>
> Kevin Huls, Fingerhut DBA
>
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
