Stop DB2 instance

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Pascal Deparis
    #1

    Stop DB2 instance

    Hi,

    When I stop my db2 instance, I have this error code :
    [db2inst3@mymach ine][/db2users/db2inst3/sqllib/db2dump][]>db2stop
    12-11-2003 16:12:48 0 0 SQL1042C An unexpected system error
    occurred.
    SQL1025N The database manager was not stopped because databases are still
    active.

    And in my db2diag.log file, I find this message below:
    DIA3605C Memory allocation failure occurred.

    I have used the ipcrm command to kill IPC processes. But the db2stop command
    failed again.

    The db2_kill command failed too:
    [db2inst3@mymach ine][/db2users/db2inst3][]>db2_kill
    rshd: 0826-813 Permission is denied.
    spk4rsh: 0041-003 No tickets file found. You need to run "k4init".
    rshd: 0826-813 Permission is denied.
    spk4rsh: 0041-003 No tickets file found. You need to run "k4init".

    Could you help me to solve this problem?
    Thanks in advance.

    Regards,

    Pascal Deparis.


    Tags: None
    • Phil Sherman
      #2
      Re: Stop DB2 instance

      If ypu are on a Linux system; did you change the kernel parameters as
      recommended in the Quick beginnings guide? I have a recollection of
      seeing something about an out-of memory condition if you haven't done that.

      Phil Sherman

      Pascal Deparis wrote:[color=blue]
      > Hi,
      >
      > When I stop my db2 instance, I have this error code :
      > [db2inst3@mymach ine][/db2users/db2inst3/sqllib/db2dump][]>db2stop
      > 12-11-2003 16:12:48 0 0 SQL1042C An unexpected system error
      > occurred.
      > SQL1025N The database manager was not stopped because databases are still
      > active.
      >
      > And in my db2diag.log file, I find this message below:
      > DIA3605C Memory allocation failure occurred.
      >
      > I have used the ipcrm command to kill IPC processes. But the db2stop command
      > failed again.
      >
      > The db2_kill command failed too:
      > [db2inst3@mymach ine][/db2users/db2inst3][]>db2_kill
      > rshd: 0826-813 Permission is denied.
      > spk4rsh: 0041-003 No tickets file found. You need to run "k4init".
      > rshd: 0826-813 Permission is denied.
      > spk4rsh: 0041-003 No tickets file found. You need to run "k4init".
      >
      > Could you help me to solve this problem?
      > Thanks in advance.
      >
      > Regards,
      >
      > Pascal Deparis.
      >
      >[/color]

        Comment

        • Pascal Deparis
          #3
          Re: Stop DB2 instance

          I'm on an AIX system, and the instance has already existed before this
          problem, and have been working very well.
          I didn't change anything.
          I tried to delete the .ftok file in the sqllib directory, as recommended by
          IBM, but it doesn't still work

          Pascal.


          "Phil Sherman" <psherman@ameri tech.net> a écrit dans le message news:
          fwvCb.16017$P%1 .14782294@newss vr28.news.prodi gy.com...[color=blue]
          > If ypu are on a Linux system; did you change the kernel parameters as
          > recommended in the Quick beginnings guide? I have a recollection of
          > seeing something about an out-of memory condition if you haven't done[/color]
          that.[color=blue]
          >
          > Phil Sherman
          >
          > Pascal Deparis wrote:[color=green]
          > > Hi,
          > >
          > > When I stop my db2 instance, I have this error code :
          > > [db2inst3@mymach ine][/db2users/db2inst3/sqllib/db2dump][]>db2stop
          > > 12-11-2003 16:12:48 0 0 SQL1042C An unexpected system error
          > > occurred.
          > > SQL1025N The database manager was not stopped because databases are[/color][/color]
          still[color=blue][color=green]
          > > active.
          > >
          > > And in my db2diag.log file, I find this message below:
          > > DIA3605C Memory allocation failure occurred.
          > >
          > > I have used the ipcrm command to kill IPC processes. But the db2stop[/color][/color]
          command[color=blue][color=green]
          > > failed again.
          > >
          > > The db2_kill command failed too:
          > > [db2inst3@mymach ine][/db2users/db2inst3][]>db2_kill
          > > rshd: 0826-813 Permission is denied.
          > > spk4rsh: 0041-003 No tickets file found. You need to run "k4init".
          > > rshd: 0826-813 Permission is denied.
          > > spk4rsh: 0041-003 No tickets file found. You need to run "k4init".
          > >
          > > Could you help me to solve this problem?
          > > Thanks in advance.
          > >
          > > Regards,
          > >
          > > Pascal Deparis.
          > >
          > >[/color]
          >[/color]


            Comment

            • Tanveer
              #4
              Re: Stop DB2 instance

              You need to setup K5MUTE=1 environment variable in /etc/environment file.
              Once you do that, you would not see the k4init message anymore.

              Cheers,

              -Tanveer



              "Pascal Deparis" <dsd@fd.net> wrote in message news:<brp6p2$t2 p$1@reader1.ima ginet.fr>...[color=blue]
              > I'm on an AIX system, and the instance has already existed before this
              > problem, and have been working very well.
              > I didn't change anything.
              > I tried to delete the .ftok file in the sqllib directory, as recommended by
              > IBM, but it doesn't still work
              >
              > Pascal.
              >
              >
              > "Phil Sherman" <psherman@ameri tech.net> a écrit dans le message news:
              > fwvCb.16017$P%1 .14782294@newss vr28.news.prodi gy.com...[color=green]
              > > If ypu are on a Linux system; did you change the kernel parameters as
              > > recommended in the Quick beginnings guide? I have a recollection of
              > > seeing something about an out-of memory condition if you haven't done[/color]
              > that.[color=green]
              > >
              > > Phil Sherman
              > >
              > > Pascal Deparis wrote:[color=darkred]
              > > > Hi,
              > > >
              > > > When I stop my db2 instance, I have this error code :
              > > > [db2inst3@mymach ine][/db2users/db2inst3/sqllib/db2dump][]>db2stop
              > > > 12-11-2003 16:12:48 0 0 SQL1042C An unexpected system error
              > > > occurred.
              > > > SQL1025N The database manager was not stopped because databases are[/color][/color]
              > still[color=green][color=darkred]
              > > > active.
              > > >
              > > > And in my db2diag.log file, I find this message below:
              > > > DIA3605C Memory allocation failure occurred.
              > > >
              > > > I have used the ipcrm command to kill IPC processes. But the db2stop[/color][/color]
              > command[color=green][color=darkred]
              > > > failed again.
              > > >
              > > > The db2_kill command failed too:
              > > > [db2inst3@mymach ine][/db2users/db2inst3][]>db2_kill
              > > > rshd: 0826-813 Permission is denied.
              > > > spk4rsh: 0041-003 No tickets file found. You need to run "k4init".
              > > > rshd: 0826-813 Permission is denied.
              > > > spk4rsh: 0041-003 No tickets file found. You need to run "k4init".
              > > >
              > > > Could you help me to solve this problem?
              > > > Thanks in advance.
              > > >
              > > > Regards,
              > > >
              > > > Pascal Deparis.
              > > >
              > > >[/color]
              > >[/color][/color]

                Comment

                Previous template Next
                Working...