Results 1 to 12 of 12
  1. #1
    Join Date
    Aug 2003
    Location
    London
    Posts
    25

    Unanswered: Stored procedure Creation Error ..

    DB : DB2 8.1.3
    OS : AIX 5L

    Dev team is not able to create stored procedure and when I see the Db2diag.log I can find the
    following errror.

    PID:2261242 TID:1 Node:000 Title: Path/Filename
    /home/... /sqllib/function/routine/sqlproc/....../tmp

    2003-09-08-18.13.43.068973 Instance:gmbd003i Node:000
    PID:2261242(db2agent (repos) 0) TID:1 Appid:*LOCAL.db2inst3.020D78171239
    PSM - SQL Procedure psm_ctrl psm_init_backend Probe:230 Database:REPOS

    DIA8402C A disk error has occurred.
    ZRC=0x860F0004

    PID:2261242 TID:1 Node:000 Title: SQL procedure initialization:
    0xDBDE4E70 : 696E 7374 616E 6365 206F 776E 6572 2064 instance owner d
    0xDBDE4E80 : 6F65 7320 6E6F 7420 6265 6C6F 6E67 2074 oes not belong t
    0xDBDE4E90 : 6F20 6665 6E63 6564 2075 7365 7227 7320 o fenced user's
    0xDBDE4EA0 : 7072 696D 6172 7920 6772 6F75 70 primary group



    How do I add instance owner to fenced user's primary group.. Any help on the same lines willbe appreciated.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Stored procedure Creation Error ..

    "How to add instance owner to the fenced user's primary group "

    You should do this at the operating system level ... With AIX you can use 'smit users'

    Stop ... But, I'm not sure why this error ? Does anyone know if this is a new requirement in V8 or is it a bug ? I could not see this requirement documented anywhere ...

    Cheers

    Sathyaram



    Originally posted by sbas
    DB : DB2 8.1.3
    OS : AIX 5L

    Dev team is not able to create stored procedure and when I see the Db2diag.log I can find the
    following errror.

    PID:2261242 TID:1 Node:000 Title: Path/Filename
    /home/... /sqllib/function/routine/sqlproc/....../tmp

    2003-09-08-18.13.43.068973 Instance:gmbd003i Node:000
    PID:2261242(db2agent (repos) 0) TID:1 Appid:*LOCAL.db2inst3.020D78171239
    PSM - SQL Procedure psm_ctrl psm_init_backend Probe:230 Database:REPOS

    DIA8402C A disk error has occurred.
    ZRC=0x860F0004

    PID:2261242 TID:1 Node:000 Title: SQL procedure initialization:
    0xDBDE4E70 : 696E 7374 616E 6365 206F 776E 6572 2064 instance owner d
    0xDBDE4E80 : 6F65 7320 6E6F 7420 6265 6C6F 6E67 2074 oes not belong t
    0xDBDE4E90 : 6F20 6665 6E63 6564 2075 7365 7227 7320 o fenced user's
    0xDBDE4EA0 : 7072 696D 6172 7920 6772 6F75 70 primary group



    How do I add instance owner to fenced user's primary group.. Any help on the same lines willbe appreciated.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2003
    Location
    London
    Posts
    25

    Re: Stored procedure Creation Error ..

    Thanks Satyaram,

    I have added that but still I did get this errors in DB2DIAG.LOG..

    I am still working on the same ....


    Regards,

    Originally posted by sathyaram_s
    "How to add instance owner to the fenced user's primary group "

    You should do this at the operating system level ... With AIX you can use 'smit users'

    Stop ... But, I'm not sure why this error ? Does anyone know if this is a new requirement in V8 or is it a bug ? I could not see this requirement documented anywhere ...

    Cheers

    Sathyaram

  4. #4
    Join Date
    Aug 2003
    Location
    London
    Posts
    25

    Re: Stored procedure Creation Error ..

    Thanks Satyaram,

    I have added that but still I did get this errors in DB2DIAG.LOG..

    I am still working on the same ....


    Regards,

    Originally posted by sathyaram_s
    "How to add instance owner to the fenced user's primary group "

    You should do this at the operating system level ... With AIX you can use 'smit users'

    Stop ... But, I'm not sure why this error ? Does anyone know if this is a new requirement in V8 or is it a bug ? I could not see this requirement documented anywhere ...

    Cheers

    Sathyaram

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Stored procedure Creation Error ..

    I think you will have to contact IBM support and open a PMR ...

    BTW, after you made changes to the group, did you stop/start instance ... Shouldn't matter, but just in case ...

    Cheers

    Sathyaram

    Originally posted by sbas
    Thanks Satyaram,

    I have added that but still I did get this errors in DB2DIAG.LOG..

    I am still working on the same ....


    Regards,
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Aug 2003
    Location
    London
    Posts
    25

    Re: Stored procedure Creation Error ..

    Satyaram,

    I re-installed the ADC again on the box and the this error seems to have disappeared from the DB2DIAG.log. "!!Strange!! "
    I am NOT sure but I assume the Fixpack "3" has made ADC corruped or invalid..




    Originally posted by sathyaram_s
    I think you will have to contact IBM support and open a PMR ...

    BTW, after you made changes to the group, did you stop/start instance ... Shouldn't matter, but just in case ...

    Cheers

    Sathyaram

  7. #7
    Join Date
    Jul 2003
    Posts
    16
    Hi,

  8. #8
    Join Date
    Jul 2003
    Posts
    16
    Hi,


    I am having similar issue.My env is db28.1 + fixpack 4a
    Initially i thought it is something to do with Hardware and reported to sysadmin people.But no results.


    What is ADC , and how do i reinstall it?

  9. #9
    Join Date
    Jan 2004
    Posts
    18
    Did anyone ever solve this problem? Or even get any feedback from IBM?

    I have added the Instance Owner to the Fenced User's Group and restarted the Instance. Alas, I still get the errors.

    Any definitive solution??

    BM.

    Quote Originally Posted by rectmaps
    Hi,


    I am having similar issue.My env is db28.1 + fixpack 4a
    Initially i thought it is something to do with Hardware and reported to sysadmin people.But no results.


    What is ADC , and how do i reinstall it?

  10. #10
    Join Date
    Mar 2004
    Posts
    448
    This is nothing to do with version,and its a bad thing to change the instance owner privileges, because you already seperated the fenced user from the instance user when you create the instance.

    I am sure that your developer also get this error, something like unable to create *.msg and some other files in tmp directory.
    there are two options, i am giving 1, figure out the other by your own.

    give the fenced user the privilage to create files in the tmp directory.

    regards,

    mujeeb

  11. #11
    Join Date
    Sep 2003
    Posts
    85
    I just happened to see the same error in our db2diag.log and found out that these messages were written when trying to create the stored proc which already existed. Once a DROP PROCEDURE was done, then during the sp creation the message was no longer produced.

  12. #12
    Join Date
    Aug 2004
    Posts
    15
    have u tried adding dev team user to prim group of fecned id?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •