Professional Web Applications Themes

File Permissions of instance changed. Help needed! - IBM DB2

I accidently made a recusive chmod which included my instance directory for UDB V8.1 on linux. Now when i try to connect to the database I get a SQL1031N (database directory cannot be found). The database manager cannot even start.. I tried to recover the permissions manually by looking at another instance but still the same error. I tried to to catalog/uncatalog everything in differenct sequences with no luck. Does anyone know how to fix this or how to "import" the database into a new instance when all the database files are intact (but the permissions wrong). Best Regards, Kenneth ...

  1. #1

    Default File Permissions of instance changed. Help needed!

    I accidently made a recusive chmod which included my instance directory for
    UDB V8.1 on linux.

    Now when i try to connect to the database I get a SQL1031N (database
    directory cannot be found).

    The database manager cannot even start..

    I tried to recover the permissions manually by looking at another instance
    but still the same error.

    I tried to to catalog/uncatalog everything in differenct sequences with no
    luck.

    Does anyone know how to fix this or how to "import" the database into a new
    instance when all the database files are intact (but the permissions
    wrong).

    Best Regards,
    Kenneth Sklander
    Kenneth Sklander Guest

  2. #2

    Default Re: File Permissions of instance changed. Help needed!

    Possibly doing an instance update may help? "db2iupdt"?

    "Kenneth Sklander" <kennethsklander.net> wrote in message
    news:Xns93BEE48FFC120kennethsklandernet62.243.74. 162...
    > I accidently made a recusive chmod which included my instance directory
    for
    > UDB V8.1 on linux.
    >
    > Now when i try to connect to the database I get a SQL1031N (database
    > directory cannot be found).
    >
    > The database manager cannot even start..
    >
    > I tried to recover the permissions manually by looking at another instance
    > but still the same error.
    >
    > I tried to to catalog/uncatalog everything in differenct sequences with no
    > luck.
    >
    > Does anyone know how to fix this or how to "import" the database into a
    new
    > instance when all the database files are intact (but the permissions
    > wrong).
    >
    > Best Regards,
    > Kenneth Sklander

    Bob [IBM] Guest

  3. #3

    Default Re: File Permissions of instance changed. Help needed!

    drop the instance (db2idrop)
    recreate the instance (db2icrt)
    catalog the database(s)

    "Bob [IBM]" <NoSpamPleaseibm.com> wrote in message news:<bfgo4n$olm$1news.btv.ibm.com>...
    > Possibly doing an instance update may help? "db2iupdt"?
    >
    > "Kenneth Sklander" <kennethsklander.net> wrote in message
    > news:Xns93BEE48FFC120kennethsklandernet62.243.74. 162...
    > > I accidently made a recusive chmod which included my instance directory
    > for
    > > UDB V8.1 on linux.
    > >
    > > Now when i try to connect to the database I get a SQL1031N (database
    > > directory cannot be found).
    > >
    > > The database manager cannot even start..
    > >
    > > I tried to recover the permissions manually by looking at another instance
    > > but still the same error.
    > >
    > > I tried to to catalog/uncatalog everything in differenct sequences with no
    > > luck.
    > >
    > > Does anyone know how to fix this or how to "import" the database into a
    > new
    > > instance when all the database files are intact (but the permissions
    > > wrong).
    > >
    > > Best Regards,
    > > Kenneth Sklander
    J. Tripper Guest

  4. #4

    Default Re: File Permissions of instance changed. Help needed!

    When I run db2idrop (as root) it returns:

    "DBI1120E Instance db2inst2 cannot be dropped.

    Explanation:

    An attempt was made to drop an instance which may still be
    active. "


    I believe its not active since no processes runs, perhaps a some file in
    the instance directory still has a "active" flag set, which the database
    has been unable to erase because of the file permissions.

    Does anyone knows if it is so, and how to remove that "flag".

    Best Regards,
    Kenneth Sklander




    [email]lobster_tee[/email] (J. Tripper) wrote in
    news:c7d8db75.0307211203.2ed50f4cposting.google.c om:
    > drop the instance (db2idrop)
    > recreate the instance (db2icrt)
    > catalog the database(s)
    >
    > "Bob [IBM]" <NoSpamPleaseibm.com> wrote in message
    > news:<bfgo4n$olm$1news.btv.ibm.com>...
    >> Possibly doing an instance update may help? "db2iupdt"?
    >>
    >> "Kenneth Sklander" <kennethsklander.net> wrote in message
    >> news:Xns93BEE48FFC120kennethsklandernet62.243.74. 162...
    >> > I accidently made a recusive chmod which included my instance
    >> > directory
    >> for
    >> > UDB V8.1 on linux.
    >> >
    >> > Now when i try to connect to the database I get a SQL1031N
    >> > (database directory cannot be found).
    >> >
    >> > The database manager cannot even start..
    >> >
    >> > I tried to recover the permissions manually by looking at another
    >> > instance but still the same error.
    >> >
    >> > I tried to to catalog/uncatalog everything in differenct sequences
    >> > with no luck.
    >> >
    >> > Does anyone know how to fix this or how to "import" the database
    >> > into a
    >> new
    >> > instance when all the database files are intact (but the
    >> > permissions wrong).
    >> >
    >> > Best Regards,
    >> > Kenneth Sklander
    >
    Kenneth Sklander Guest

  5. #5

    Default Re: File Permissions of instance changed. Help needed!

    Kenneth Sklander wrote:
    > When I run db2idrop (as root) it returns:
    >
    > "DBI1120E Instance db2inst2 cannot be dropped.
    >
    > Explanation:
    >
    > An attempt was made to drop an instance which may still be
    > active. "
    >
    >
    > I believe its not active since no processes runs, perhaps a some file in
    > the instance directory still has a "active" flag set, which the database
    > has been unable to erase because of the file permissions.
    >
    > Does anyone knows if it is so, and how to remove that "flag".
    >
    > Best Regards,
    > Kenneth Sklander
    When all else fails, try renaming sqllib/adm/db2stop to something else, say
    sqllib/adm/db2stop.right.now

    If that doesn't help, get a trace of the drop and send it to me.

    # db2idrop -d db2inst2 2>&1 | tee /tmp/db2idrop.trc

    Thanks,
    Darin McBride Guest

  6. #6

    Default Re: File Permissions of instance changed. Help needed!

    If you the command "db2stop force" did not help.
    I think you can try:
    set db2 auto restart to NO
    restart the Linux
    drop the instance through the db2idrop
    Regards,
    FRX

    Darin McBride wrote:
    > Kenneth Sklander wrote:
    >
    > > When I run db2idrop (as root) it returns:
    > >
    > > "DBI1120E Instance db2inst2 cannot be dropped.
    > >
    > > Explanation:
    > >
    > > An attempt was made to drop an instance which may still be
    > > active. "
    > >
    > >
    > > I believe its not active since no processes runs, perhaps a some file in
    > > the instance directory still has a "active" flag set, which the database
    > > has been unable to erase because of the file permissions.
    > >
    > > Does anyone knows if it is so, and how to remove that "flag".
    > >
    > > Best Regards,
    > > Kenneth Sklander
    >
    > When all else fails, try renaming sqllib/adm/db2stop to something else, say
    > sqllib/adm/db2stop.right.now
    >
    > If that doesn't help, get a trace of the drop and send it to me.
    >
    > # db2idrop -d db2inst2 2>&1 | tee /tmp/db2idrop.trc
    >
    > Thanks,
    Fan Ruo Xin Guest

  7. #7

    Default Re: File Permissions of instance changed. Help needed!

    I renamed db2stop and ran and it gave the same output:
    "07-22-2003 02:09:29 0 0 SQL6048N A communication error
    occurred during START or STOP DATABASE MANAGER processing.
    SQL1025N The database manager was not stopped because databases are
    still active."

    with the force parameter
    "SQL6033W Stop command processing was attempted on "1" node(s). "0"
    node(s) were successfully stopped. "0" node(s) were already stopped.
    "0" node(s) could not be stopped."

    The trace from the db2idrop command is below.

    Thanks,
    Kenneth

    + trap 'stop_prog 2' 1 2 3 15
    + cleanup
    + set -x
    + rmlog=no
    + rm -f /tmp/db2idrop.user.2486 /tmp/db2idrop.tmp1.2486
    /tmp/db2idrop.tmp2.2486 /tmp/db2idrop.tmp3.2486
    + '[' 0 -eq 1 ']'
    + '[' -f /tmp/db2idrop.log.2486 ']'
    + '[' -x /opt/IBM/db2/V8.1/instance/dlfmlist ']'
    + '[' -x /opt/IBM/db2/V8.1/instance/dqplist ']'
    + drop_instance
    + trac drop_instance
    + '[' 0 -eq 0 ']'
    + echo '## call function drop_instance'
    + tee -a /tmp/db2idrop.log.2486
    ## call function drop_instance
    + set -x
    + get_instance db2inst2
    + trac get_instance db2inst2
    + '[' 0 -eq 0 ']'
    + echo '## call function get_instance' db2inst2
    + tee -a /tmp/db2idrop.log.2486
    ## call function get_instance db2inst2
    + set -x
    + find_homedir db2inst2
    + trac find_homedir db2inst2
    + '[' 0 -eq 0 ']'
    + echo '## call function find_homedir' db2inst2
    + tee -a /tmp/db2idrop.log.2486
    ## call function find_homedir db2inst2
    + set -x
    + username=db2inst2
    + /opt/IBM/db2/V8.1/bin/db2usrinf -q db2inst2
    ++ /opt/IBM/db2/V8.1/bin/db2usrinf -d db2inst2
    + USERHOME=/home/db2inst2
    + dmsg 'User home dir = /home/db2inst2'
    + '[' 0 -eq 0 ']'
    + echo '## User home dir = /home/db2inst2'
    + tee -a /tmp/db2idrop.log.2486
    ## User home dir = /home/db2inst2
    + trax find_homedir
    + '[' 0 -eq 0 ']'
    + echo '## exit function find_homedir'
    + tee -a /tmp/db2idrop.log.2486
    ## exit function find_homedir
    + return 0
    + INSTHOME=/home/db2inst2
    + find_primgrp db2inst2
    + trac find_primgrp db2inst2
    + '[' 0 -eq 0 ']'
    + echo '## call function find_primgrp' db2inst2
    + tee -a /tmp/db2idrop.log.2486
    ## call function find_primgrp db2inst2
    + set -x
    + username=db2inst2
    + /opt/IBM/db2/V8.1/bin/db2usrinf -q db2inst2
    ++ /opt/IBM/db2/V8.1/bin/db2usrinf -g db2inst2
    + USERPGRP=db2grp1
    + '[' -z db2grp1 ']'
    + dmsg 'User primary group = db2grp1'
    + '[' 0 -eq 0 ']'
    + echo '## User primary group = db2grp1'
    + tee -a /tmp/db2idrop.log.2486
    ## User primary group = db2grp1
    + trax find_primgrp
    + '[' 0 -eq 0 ']'
    + echo '## exit function find_primgrp'
    + tee -a /tmp/db2idrop.log.2486
    ## exit function find_primgrp
    + return 0
    + '[' 0 -eq 0 ']'
    + INSTPGRP=db2grp1
    ++ echo db2inst2
    ++ awk '{print length($1)}'
    + instidlen=8
    + '[' 8 -gt 8 ']'
    ++ echo db2grp1
    ++ awk '{print length($1)}'
    + instgrplen=7
    + '[' 7 -gt 8 ']'
    + EXIT_INVALID_USER=2
    + EXIT_INVALID_GROUP=3
    + /opt/IBM/db2/V8.1/instance/db2icknm db2inst2 db2grp1
    + exitcode=0
    + '[' 0 -eq 2 ']'
    + '[' 0 -eq 3 ']'
    + '[' 0 -ne 0 ']'
    + INSTCTRLDIR=/home/db2inst2/sqllib/ctrl
    + FENCINFOFILE=/home/db2inst2/sqllib/ctrl/.fencedID
    + ITYPEFILE=/home/db2inst2/sqllib/ctrl/.insttype
    + query_instuse db2inst2 BitWidth 0
    + trac query_instuse db2inst2 BitWidth 0
    + '[' 0 -eq 0 ']'
    + echo '## call function query_instuse' db2inst2 BitWidth 0
    + tee -a /tmp/db2idrop.log.2486
    ## call function query_instuse db2inst2 BitWidth 0
    + set -x
    + query_instuse_string db2inst2 BitWidth 0
    + trac query_instuse_string db2inst2 BitWidth 0
    + '[' 0 -eq 0 ']'
    + echo '## call function query_instuse_string' db2inst2 BitWidth 0
    + tee -a /tmp/db2idrop.log.2486
    ## call function query_instuse_string db2inst2 BitWidth 0
    + set -x
    + INST2QUERY=db2inst2
    + DB2FTN=BitWidth
    + DEFAULT=0
    + CMD_DB2FUPDT=/opt/IBM/db2/V8.1/bin/db2fupdt
    + find_homedir db2inst2
    + trac find_homedir db2inst2
    + '[' 0 -eq 0 ']'
    + echo '## call function find_homedir' db2inst2
    + tee -a /tmp/db2idrop.log.2486
    ## call function find_homedir db2inst2
    + set -x
    + username=db2inst2
    + /opt/IBM/db2/V8.1/bin/db2usrinf -q db2inst2
    ++ /opt/IBM/db2/V8.1/bin/db2usrinf -d db2inst2
    + USERHOME=/home/db2inst2
    + dmsg 'User home dir = /home/db2inst2'
    + '[' 0 -eq 0 ']'
    + echo '## User home dir = /home/db2inst2'
    + tee -a /tmp/db2idrop.log.2486
    ## User home dir = /home/db2inst2
    + trax find_homedir
    + '[' 0 -eq 0 ']'
    + echo '## exit function find_homedir'
    + tee -a /tmp/db2idrop.log.2486
    ## exit function find_homedir
    + return 0
    + INSTUSE=/home/db2inst2/sqllib/ctrl/.instuse
    ++ /opt/IBM/db2/V8.1/bin/db2fupdt -f /home/db2inst2/sqllib/ctrl/.instuse
    -p BitWidth
    + INSTUSE_VALUE=32
    + rc=0
    + '[' 0 -ne 0 ']'
    + return 0
    + trax query_instuse
    + '[' 0 -eq 0 ']'
    + echo '## exit function query_instuse'
    + tee -a /tmp/db2idrop.log.2486
    ## exit function query_instuse
    + return 32
    + INSTBITWIDTH=32
    + '[' 32 -eq 0 -a -d /home/db2inst2/sqllib/ctrl ']'
    + ORIGBITWIDTH=32
    + gen_bitdirnames
    + suffix=
    + '[' 32 -eq 64 ']'
    + VARDIROLDNAMES=
    + VARDIRNEWNAMES=
    + eval DIR_adm=adm
    ++ DIR_adm=adm
    + VARDIROLDNAMES= adm
    + VARDIRNEWNAMES= adm
    + eval DIR_adsm=adsm
    ++ DIR_adsm=adsm
    + VARDIROLDNAMES= adm adsm
    + VARDIRNEWNAMES= adm adsm
    + eval DIR_bin=bin
    ++ DIR_bin=bin
    + VARDIROLDNAMES= adm adsm bin
    + VARDIRNEWNAMES= adm adsm bin
    + eval DIR_function=function
    ++ DIR_function=function
    + VARDIROLDNAMES= adm adsm bin function
    + VARDIRNEWNAMES= adm adsm bin function
    + eval DIR_include=include
    ++ DIR_include=include
    + VARDIROLDNAMES= adm adsm bin function include
    + VARDIRNEWNAMES= adm adsm bin function include
    + eval DIR_lib=lib
    ++ DIR_lib=lib
    + VARDIROLDNAMES= adm adsm bin function include lib
    + VARDIRNEWNAMES= adm adsm bin function include lib
    + eval DIR_security=security
    ++ DIR_security=security
    + VARDIROLDNAMES= adm adsm bin function include lib security
    + VARDIRNEWNAMES= adm adsm bin function include lib security
    + dmsg 'INSTNAME = db2inst2'
    + '[' 0 -eq 0 ']'
    + echo '## INSTNAME = db2inst2'
    + tee -a /tmp/db2idrop.log.2486
    ## INSTNAME = db2inst2
    + dmsg 'INSTPGRP = db2grp1'
    + '[' 0 -eq 0 ']'
    + echo '## INSTPGRP = db2grp1'
    + tee -a /tmp/db2idrop.log.2486
    ## INSTPGRP = db2grp1
    + dmsg 'INSTHOME = /home/db2inst2'
    + '[' 0 -eq 0 ']'
    + echo '## INSTHOME = /home/db2inst2'
    + tee -a /tmp/db2idrop.log.2486
    ## INSTHOME = /home/db2inst2
    + dmsg 'INSTCTRLDIR = /home/db2inst2/sqllib/ctrl'
    + '[' 0 -eq 0 ']'
    + echo '## INSTCTRLDIR = /home/db2inst2/sqllib/ctrl'
    + tee -a /tmp/db2idrop.log.2486
    ## INSTCTRLDIR = /home/db2inst2/sqllib/ctrl
    + dmsg 'FENCINFOFILE = /home/db2inst2/sqllib/ctrl/.fencedID'
    + '[' 0 -eq 0 ']'
    + echo '## FENCINFOFILE = /home/db2inst2/sqllib/ctrl/.fencedID'
    + tee -a /tmp/db2idrop.log.2486
    ## FENCINFOFILE = /home/db2inst2/sqllib/ctrl/.fencedID
    + dmsg 'ITYPEFILE = /home/db2inst2/sqllib/ctrl/.insttype'
    + '[' 0 -eq 0 ']'
    + echo '## ITYPEFILE = /home/db2inst2/sqllib/ctrl/.insttype'
    + tee -a /tmp/db2idrop.log.2486
    ## ITYPEFILE = /home/db2inst2/sqllib/ctrl/.insttype
    + dmsg 'INSTBITWIDTH = 32'
    + '[' 0 -eq 0 ']'
    + echo '## INSTBITWIDTH = 32'
    + tee -a /tmp/db2idrop.log.2486
    ## INSTBITWIDTH = 32
    + trax get_instance
    + '[' 0 -eq 0 ']'
    + echo '## exit function get_instance'
    + tee -a /tmp/db2idrop.log.2486
    ## exit function get_instance
    + return 0
    + def_specials
    + set -x
    + EXIT_APPL_ACTIVE=10
    + EXIT_SRV_MISSING=20
    + BAKDIRNAME=backup
    + SQLLIBBACKUP=/home/db2inst2/sqllib/backup
    + OLDDB2SYSTM=db2systm.old
    + OLDDB2PROFILE=db2profile.old
    + OLDDB2CSHRC=db2cshrc.old
    + LSTDBDIR=dbdir.lst
    + LSTNODEDIR=nodedir.lst
    + LSTDCSDIR=dcsdir.lst
    + LSTDBMCFG=dbmcfg.lst
    + LOGDIRMIGR=dirmigr.log
    + chk_version db2inst2
    + trac chk_version db2inst2
    + '[' 0 -eq 0 ']'
    + echo '## call function chk_version' db2inst2
    + tee -a /tmp/db2idrop.log.2486
    ## call function chk_version db2inst2
    + set -x
    + instname=db2inst2
    + db2version=199
    + db2proddir=UNKNOWN
    + find_homedir db2inst2
    + trac find_homedir db2inst2
    + '[' 0 -eq 0 ']'
    + echo '## call function find_homedir' db2inst2
    + tee -a /tmp/db2idrop.log.2486
    ## call function find_homedir db2inst2
    + set -x
    + username=db2inst2
    + /opt/IBM/db2/V8.1/bin/db2usrinf -q db2inst2
    ++ /opt/IBM/db2/V8.1/bin/db2usrinf -d db2inst2
    + USERHOME=/home/db2inst2
    + dmsg 'User home dir = /home/db2inst2'
    + '[' 0 -eq 0 ']'
    + echo '## User home dir = /home/db2inst2'
    + tee -a /tmp/db2idrop.log.2486
    ## User home dir = /home/db2inst2
    + trax find_homedir
    + '[' 0 -eq 0 ']'
    + echo '## exit function find_homedir'
    + tee -a /tmp/db2idrop.log.2486
    ## exit function find_homedir
    + return 0
    + instlibdir=/home/db2inst2/sqllib/lib
    + '[' '!' -d /home/db2inst2/sqllib/lib ']'
    + query_instuse_string db2inst2 INSTVER 0
    + trac query_instuse_string db2inst2 INSTVER 0
    + '[' 0 -eq 0 ']'
    + echo '## call function query_instuse_string' db2inst2 INSTVER 0
    + tee -a /tmp/db2idrop.log.2486
    ## call function query_instuse_string db2inst2 INSTVER 0
    + set -x
    + INST2QUERY=db2inst2
    + DB2FTN=INSTVER
    + DEFAULT=0
    + CMD_DB2FUPDT=/opt/IBM/db2/V8.1/bin/db2fupdt
    + find_homedir db2inst2
    + trac find_homedir db2inst2
    + '[' 0 -eq 0 ']'
    + echo '## call function find_homedir' db2inst2
    + tee -a /tmp/db2idrop.log.2486
    ## call function find_homedir db2inst2
    + set -x
    + username=db2inst2
    + /opt/IBM/db2/V8.1/bin/db2usrinf -q db2inst2
    ++ /opt/IBM/db2/V8.1/bin/db2usrinf -d db2inst2
    + USERHOME=/home/db2inst2
    + dmsg 'User home dir = /home/db2inst2'
    + '[' 0 -eq 0 ']'
    + echo '## User home dir = /home/db2inst2'
    + tee -a /tmp/db2idrop.log.2486
    ## User home dir = /home/db2inst2
    + trax find_homedir
    + '[' 0 -eq 0 ']'
    + echo '## exit function find_homedir'
    + tee -a /tmp/db2idrop.log.2486
    ## exit function find_homedir
    + return 0
    + INSTUSE=/home/db2inst2/sqllib/ctrl/.instuse
    ++ /opt/IBM/db2/V8.1/bin/db2fupdt -f /home/db2inst2/sqllib/ctrl/.instuse
    -p INSTVER
    + INSTUSE_VALUE=81
    + rc=0
    + '[' 0 -ne 0 ']'
    + return 0
    + dmsg 'INSTUSE_VALUE for INSTVER is 81'
    + '[' 0 -eq 0 ']'
    + echo '## INSTUSE_VALUE for INSTVER is 81'
    + tee -a /tmp/db2idrop.log.2486
    ## INSTUSE_VALUE for INSTVER is 81
    + '[' X81 = X81 ']'
    + db2version=81
    + query_instuse_string db2inst2 DB2DIR /opt/IBM/db2/V8.1
    + trac query_instuse_string db2inst2 DB2DIR /opt/IBM/db2/V8.1
    + '[' 0 -eq 0 ']'
    + echo '## call function query_instuse_string' db2inst2 DB2DIR
    /opt/IBM/db2/V8.1
    + tee -a /tmp/db2idrop.log.2486
    ## call function query_instuse_string db2inst2 DB2DIR /opt/IBM/db2/V8.1
    + set -x
    + INST2QUERY=db2inst2
    + DB2FTN=DB2DIR
    + DEFAULT=/opt/IBM/db2/V8.1
    + CMD_DB2FUPDT=/opt/IBM/db2/V8.1/bin/db2fupdt
    + find_homedir db2inst2
    + trac find_homedir db2inst2
    + '[' 0 -eq 0 ']'
    + echo '## call function find_homedir' db2inst2
    + tee -a /tmp/db2idrop.log.2486
    ## call function find_homedir db2inst2
    + set -x
    + username=db2inst2
    + /opt/IBM/db2/V8.1/bin/db2usrinf -q db2inst2
    ++ /opt/IBM/db2/V8.1/bin/db2usrinf -d db2inst2
    + USERHOME=/home/db2inst2
    + dmsg 'User home dir = /home/db2inst2'
    + '[' 0 -eq 0 ']'
    + echo '## User home dir = /home/db2inst2'
    + tee -a /tmp/db2idrop.log.2486
    ## User home dir = /home/db2inst2
    + trax find_homedir
    + '[' 0 -eq 0 ']'
    + echo '## exit function find_homedir'
    + tee -a /tmp/db2idrop.log.2486
    ## exit function find_homedir
    + return 0
    + INSTUSE=/home/db2inst2/sqllib/ctrl/.instuse
    ++ /opt/IBM/db2/V8.1/bin/db2fupdt -f /home/db2inst2/sqllib/ctrl/.instuse
    -p DB2DIR
    + INSTUSE_VALUE=/opt/IBM/db2/V8.1
    + rc=0
    + '[' 0 -ne 0 ']'
    + return 0
    + dmsg 'INSTUSE_VALUE for DB2DIR is /opt/IBM/db2/V8.1'
    + '[' 0 -eq 0 ']'
    + echo '## INSTUSE_VALUE for DB2DIR is /opt/IBM/db2/V8.1'
    + tee -a /tmp/db2idrop.log.2486
    ## INSTUSE_VALUE for DB2DIR is /opt/IBM/db2/V8.1
    + db2proddir=/opt/IBM/db2/V8.1
    + return 81
    + DB2INSTVER=81
    + DB2IPRDDIR=/opt/IBM/db2/V8.1
    + '[' 81 '!=' 199 ']'
    + '[' -d /home/db2inst2/sqllib/lib ']'
    + terminate_instance 1 db2inst2 db2inst2 /home/db2inst2 81
    /opt/IBM/db2/V8.1
    + trac terminate_instance 1 db2inst2 db2inst2 /home/db2inst2 81
    /opt/IBM/db2/V8.1
    + '[' 0 -eq 0 ']'
    + echo '## call function terminate_instance' 1 db2inst2 db2inst2
    /home/db2inst2 81 /opt/IBM/db2/V8.1
    + tee -a /tmp/db2idrop.log.2486
    ## call function terminate_instance 1 db2inst2 db2inst2 /home/db2inst2
    81 /opt/IBM/db2/V8.1
    + set -x
    + '[' 6 -eq 6 -o 6 -eq 7 ']'
    + :
    + force=1
    + '[' 6 -eq 7 ']'
    + nodenum=-n 0
    + sysadm=db2inst2
    + instname=db2inst2
    + insthome=/home/db2inst2
    + db2version=81
    + db2proddir=/opt/IBM/db2/V8.1
    + '[' 1 -eq 0 ']'
    + argforce=
    + rm -f /tmp/db2idrop.tmp3.2486
    + status=1
    + su - db2inst2 -c '/opt/IBM/db2/V8.1/instance/db2istop -n
    0 db2inst2 /home/db2inst2 81 /opt/IBM/db2/V8.1
    /tmp/db2idrop.tmp3.2486'
    + status=10
    + '[' -s /tmp/db2idrop.tmp3.2486 ']'
    + cat /tmp/db2idrop.tmp3.2486
    + rm -f /tmp/db2idrop.tmp3.2486
    + display_msg /opt/IBM/db2/V8.1/msg/en_US.iso88591/db2install.cat 250
    'DBI1250E Applications are still using instance %s.\n' db2inst2
    + set -x
    + unset catname msgid deftmsg msgstr warnmsg infomsg
    + catname=/opt/IBM/db2/V8.1/msg/en_US.iso88591/db2install.cat
    + msgid=250
    + deftmsg=DBI1250E Applications are still using instance %s.\n
    + warnmsg=1
    + infomsg=1
    + echo DBI1250E Applications are still using instance '%s.\n'
    + grep DBI....W
    + '[' 1 -eq 0 ']'
    + echo DBI1250E Applications are still using instance '%s.\n'
    + grep DBI....I
    + '[' 1 -eq 0 ']'
    + '[' 1 -eq 0 ']'
    + '[' 1 -eq 1 -a 1 -eq 1 ']'
    ++ expr 0 + 1
    + MSGCOUNT=1
    + shift
    + shift
    + shift
    + /opt/IBM/db2/V8.1/instance/disp_msg 1 250
    /opt/IBM/db2/V8.1/msg/en_US.iso88591/db2install.cat 'DBI1250E
    Applications are still using instance %s.\n' db2inst2
    + tee -a /tmp/db2idrop.log.2486
    DBI1250E Applications are still using instance
    db2inst2.

    Explanation:

    There are applications that are still running that are using the
    specified instance. All applications using this instance must be
    terminated before the command can be completed successfully. You
    can get a list of the applications that are currently using the
    instance by issuing the command:


    db2 list applications

    User Response:

    You can either wait for the applications to end by themselves, or
    you can explicitly force the applications to end. You can logon
    as the instance owner and run the command


    db2 force application all

    Note that some applications may have unexpected behaviour when
    terminated using the above command. After all the applications
    have stopped, stop the database manager using "db2istop"
    command.


    + trax terminate_instance
    + '[' 0 -eq 0 ']'
    + echo '## exit function terminate_instance'
    + tee -a /tmp/db2idrop.log.2486
    ## exit function terminate_instance
    + return 10
    + '[' 10 -ne 0 ']'
    + display_msg /opt/IBM/db2/V8.1/msg/en_US.iso88591/db2install.cat 120
    'DBI1120E Instance %s cannot be dropped.\n' db2inst2
    + set -x
    + unset catname msgid deftmsg msgstr warnmsg infomsg
    + catname=/opt/IBM/db2/V8.1/msg/en_US.iso88591/db2install.cat
    + msgid=120
    + deftmsg=DBI1120E Instance %s cannot be dropped.\n
    + warnmsg=1
    + infomsg=1
    + echo DBI1120E Instance %s cannot be 'dropped.\n'
    + grep DBI....W
    + '[' 1 -eq 0 ']'
    + echo DBI1120E Instance %s cannot be 'dropped.\n'
    + grep DBI....I
    + '[' 1 -eq 0 ']'
    + '[' 1 -eq 0 ']'
    + '[' 1 -eq 1 -a 1 -eq 1 ']'
    ++ expr 1 + 1
    + MSGCOUNT=2
    + shift
    + shift
    + shift
    + /opt/IBM/db2/V8.1/instance/disp_msg 1 120
    /opt/IBM/db2/V8.1/msg/en_US.iso88591/db2install.cat 'DBI1120E Instance %
    s cannot be dropped.\n' db2inst2
    + tee -a /tmp/db2idrop.log.2486
    DBI1120E Instance db2inst2 cannot be dropped.

    Explanation:

    An attempt was made to drop an instance which may still be
    active.


    + stop_prog 1
    + set -x
    + sig=1
    + '[' 1 -eq 2 ']'
    + '[' 1 -gt 2 ']'
    + cleanup
    + set -x
    + rmlog=no
    + rm -f /tmp/db2idrop.user.2486 /tmp/db2idrop.tmp1.2486
    /tmp/db2idrop.tmp2.2486 /tmp/db2idrop.tmp3.2486
    + '[' 0 -eq 1 ']'
    + '[' -f /tmp/db2idrop.log.2486 ']'
    + display_msg /opt/IBM/db2/V8.1/msg/en_US.iso88591/db2install.cat 79
    'DBI1079I Output is saved in the log file %s.' /tmp/db2idrop.log.2486
    + set -x
    + unset catname msgid deftmsg msgstr warnmsg infomsg
    + catname=/opt/IBM/db2/V8.1/msg/en_US.iso88591/db2install.cat
    + msgid=79
    + deftmsg=DBI1079I Output is saved in the log file %s.
    + warnmsg=1
    + infomsg=1
    + echo DBI1079I Output is saved in the log file %s.
    + grep DBI....W
    + '[' 1 -eq 0 ']'
    + echo DBI1079I Output is saved in the log file %s.
    + grep DBI....I
    + '[' 0 -eq 0 ']'
    + infomsg=0
    + '[' 1 -eq 0 ']'
    + '[' 1 -eq 1 -a 0 -eq 1 ']'
    + shift
    + shift
    + shift
    + /opt/IBM/db2/V8.1/instance/disp_msg 1 79
    /opt/IBM/db2/V8.1/msg/en_US.iso88591/db2install.cat 'DBI1079I Output is
    saved in the log file %s.' /tmp/db2idrop.log.2486
    + tee -a /tmp/db2idrop.log.2486
    DBI1079I Output is saved in the log file /tmp/db2idrop.log.2486.

    Explanation:

    All processed and failed operations have been saved into this log
    file.

    User Response:

    Do not modify this file in any way. This file is for IBM
    Technical Support reference.


    + '[' 1 -eq 0 ']'
    + '[' 1 -eq 0 ']'
    + exit 1


    ***********************

    Darin McBride <dmcbridenaboo.to.org.no.spam.for.me> wrote in
    news:2nZSa.481572$ro6.11491441news2.calgary.shaw. ca:
    > Kenneth Sklander wrote:
    >
    >> When I run db2idrop (as root) it returns:
    >>
    >> "DBI1120E Instance db2inst2 cannot be dropped.
    >>
    >> Explanation:
    >>
    >> An attempt was made to drop an instance which may still be
    >> active. "
    >>
    >>
    >> I believe its not active since no processes runs, perhaps a some file
    >> in the instance directory still has a "active" flag set, which the
    >> database has been unable to erase because of the file permissions.
    >>
    >> Does anyone knows if it is so, and how to remove that "flag".
    >>
    >> Best Regards,
    >> Kenneth Sklander
    >
    > When all else fails, try renaming sqllib/adm/db2stop to something
    > else, say sqllib/adm/db2stop.right.now
    >
    > If that doesn't help, get a trace of the drop and send it to me.
    >
    > # db2idrop -d db2inst2 2>&1 | tee /tmp/db2idrop.trc
    >
    > Thanks,
    Kenneth Sklander Guest

  8. #8

    Default Re: File Permissions of instance changed. Help needed!

    I tried the command 'db2nkill 0'

    and then dropped and created the instance
    catalogged the database
    and now it seems to work :)

    Thank for the help,
    Kenneth

    Kenneth Sklander <kennethsklander.net> wrote in
    news:Xns93BEE48FFC120kennethsklandernet62.243.74. 162:


    > I accidently made a recusive chmod which included my instance
    > directory for UDB V8.1 on linux.
    >
    > Now when i try to connect to the database I get a SQL1031N (database
    > directory cannot be found).
    >
    > The database manager cannot even start..
    >
    > I tried to recover the permissions manually by looking at another
    > instance but still the same error.
    >
    > I tried to to catalog/uncatalog everything in differenct sequences
    > with no luck.
    >
    > Does anyone know how to fix this or how to "import" the database into
    > a new instance when all the database files are intact (but the
    > permissions wrong).
    >
    > Best Regards,
    > Kenneth Sklander
    Kenneth Sklander Guest

Similar Threads

  1. Replies: 4
    Last Post: April 4th, 01:05 PM
  2. Changed .CFC file, but CF still uses old version
    By Mister_HW in forum Macromedia ColdFusion
    Replies: 1
    Last Post: April 16th, 10:07 AM
  3. Using the Jscript to update the ASPNET account to have the needed permissions
    By Giang Thanh via .NET 247 in forum ASP.NET Security
    Replies: 0
    Last Post: May 6th, 08:29 AM
  4. File name changed & can't open!
    By CarolE2B@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 1
    Last Post: April 16th, 05:08 PM
  5. Open file, make changes, save file, close, re-open, file contents not changed
    By brock@bergdesign.com in forum Adobe Illustrator Macintosh
    Replies: 7
    Last Post: March 7th, 07:29 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139