SEO

#1 (**permalink**) 02-27-2008, 12:46 PM

I create a new instance yesterday, now I cannot stop it, or perform
any instance level operation like setup db2comm using instance id.

The error message is "SQL1092N does not have the authority to perform
the requested command". I check the authorization, the instance id
have sysadm authority.

The only message in db2diag.log is :

"FUNCTION: DB2 Common, Fault Monitor Facility, fmGetGcfModuleName,
probe:30
MESSAGE : ECF=0x90000373 The gcf module to be loaded does not follow
name convention libgcf[XXX]
DATA #1 : String, 41 bytes
/home/db2inst1/sqllib/lib/libdb2gcf.a
DATA #2 : String, 11 bytes
libdb2gcf.a

I check the lib folder, there are three modules starting with libgcf.
$ ls -l libgcf*
-r--r--r-- 1 bin bin 31506 Aug 02 2006 libgcf.a
-r--r--r-- 1 bin bin 80013 Aug 02 2006 libgcffm.a
-r--r--r-- 1 bin bin 79806 Aug 02 2006 libgcffmcmd.a

Any suggestion? Will it help if I ask Unix admin to disable fault
monitor coordinator and related processes?

#2 (**permalink**) 02-27-2008, 12:46 PM

i would disable the fault monitor daemon first and try the simple
db2stop / db2start to see if it works... next i will double check the
SYSADM group name and see if the instance owning ID belongs to it or
not, specially check for any typo errors anywhere....

regards,
dotyet

On Jun 14, 11:23 am, ebusiness <wendy_...@hotmail.com> wrote:
> I create a new instance yesterday, now I cannot stop it, or perform
> any instance level operation like setup db2comm using instance id.
>
> The error message is "SQL1092N does not have the authority to perform
> the requested command". I check the authorization, the instance id
> have sysadm authority.
>
> The only message in db2diag.log is :
>
> "FUNCTION: DB2 Common, Fault Monitor Facility, fmGetGcfModuleName,
> probe:30
> MESSAGE : ECF=0x90000373 The gcf module to be loaded does not follow
> name convention libgcf[XXX]
> DATA #1 : String, 41 bytes
> /home/db2inst1/sqllib/lib/libdb2gcf.a
> DATA #2 : String, 11 bytes
> libdb2gcf.a
>
> I check the lib folder, there are three modules starting with libgcf.
> $ ls -l libgcf*
> -r--r--r-- 1 bin bin 31506 Aug 02 2006 libgcf.a
> -r--r--r-- 1 bin bin 80013 Aug 02 2006 libgcffm.a
> -r--r--r-- 1 bin bin 79806 Aug 02 2006 libgcffmcmd.a
>
> Any suggestion? Will it help if I ask Unix admin to disable fault
> monitor coordinator and related processes?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

instance owner can't stop the instance