DB2 daily

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

    DB2 daily

    Coming from Oracle background:

    How do you carry thiese admin tasks in DB2 Environment :

    Check instance availability
    Check listener availability
    Check alert log files for error messages
    Clean up old log files before log destination gets filled
    Analyze tables and indexes for better performance
    Check tablespace usage
    Find out invalid objects
    Monitor users and transactions


    Thanks for help.
    Tags: None
    • Anton Versteeg
      #2
      Re: DB2 daily

      See below for possible commands, etc.
      Not complete but should get started

      Frank wrote:[color=blue]
      > Coming from Oracle background:
      >
      > How do you carry thiese admin tasks in DB2 Environment :
      >
      > Check instance availability[/color]
      connect to instname[color=blue]
      > Check listener availability[/color]
      same plus connect to database[color=blue]
      > Check alert log files for error messages[/color]
      grep from db2diag.log[color=blue]
      > Clean up old log files before log destination gets filled[/color]
      what log files are you refering to? transaction (redo) log files?[color=blue]
      > Analyze tables and indexes for better performance[/color]
      reorgchk command[color=blue]
      > Check tablespace usage[/color]
      list tablespaces show detail[color=blue]
      > Find out invalid objects[/color]
      select from syscat.tables (for invalid views)
      list packages
      etc[color=blue]
      > Monitor users and transactions[/color]
      connect to instance
      list applications
      or via db2 monitor commands[color=blue]
      >
      >
      > Thanks for help.[/color]

      --
      Anton Versteeg
      IBM Certified DB2 Specialist
      IBM Netherlands

        Comment

        • Anton Versteeg
          #3
          Re: DB2 daily

          See below for possible commands, etc.
          Not complete but should get started

          Frank wrote:[color=blue]
          > Coming from Oracle background:
          >
          > How do you carry thiese admin tasks in DB2 Environment :
          >
          > Check instance availability[/color]
          connect to instname[color=blue]
          > Check listener availability[/color]
          same plus connect to database[color=blue]
          > Check alert log files for error messages[/color]
          grep from db2diag.log[color=blue]
          > Clean up old log files before log destination gets filled[/color]
          what log files are you refering to? transaction (redo) log files?[color=blue]
          > Analyze tables and indexes for better performance[/color]
          reorgchk command[color=blue]
          > Check tablespace usage[/color]
          list tablespaces show detail[color=blue]
          > Find out invalid objects[/color]
          select from syscat.tables (for invalid views)
          list packages
          etc[color=blue]
          > Monitor users and transactions[/color]
          connect to instance
          list applications
          or via db2 monitor commands[color=blue]
          >
          >
          > Thanks for help.[/color]

          --
          Anton Versteeg
          IBM Certified DB2 Specialist
          IBM Netherlands

            Comment

            • Mark A
              #4
              Re: DB2 daily

              "Anton Versteeg" <anton_versteeg @nnll.ibm.com> wrote in message
              news:c6ar5v$1q7 m$1@sp15en20.hu rsley.ibm.com.. .[color=blue]
              > See below for possible commands, etc.
              > Not complete but should get started
              >
              > Frank wrote:[color=green]
              > > Coming from Oracle background:
              > >
              > > How do you carry thiese admin tasks in DB2 Environment :
              > >
              > > Check instance availability[/color]
              > connect to instname[/color]

              Isn't that "attach to instance"?



                Comment

                • Mark A
                  #5
                  Re: DB2 daily

                  "Anton Versteeg" <anton_versteeg @nnll.ibm.com> wrote in message
                  news:c6ar5v$1q7 m$1@sp15en20.hu rsley.ibm.com.. .[color=blue]
                  > See below for possible commands, etc.
                  > Not complete but should get started
                  >
                  > Frank wrote:[color=green]
                  > > Coming from Oracle background:
                  > >
                  > > How do you carry thiese admin tasks in DB2 Environment :
                  > >
                  > > Check instance availability[/color]
                  > connect to instname[/color]

                  Isn't that "attach to instance"?



                    Comment

                    • Philip Nelson
                      #6
                      Re: DB2 daily

                      Frank wrote:
                      [color=blue]
                      > Coming from Oracle background:
                      >
                      > How do you carry thiese admin tasks in DB2 Environment :
                      >
                      > Check instance availability
                      > Check listener availability
                      > Check alert log files for error messages
                      > Clean up old log files before log destination gets filled
                      > Analyze tables and indexes for better performance
                      > Check tablespace usage
                      > Find out invalid objects
                      > Monitor users and transactions
                      >
                      >
                      > Thanks for help.[/color]

                      Before getting into writing anything yourself, I'd suggest you check out the
                      "Health Center" (assuming you are on V8). It automates a lot of the
                      mundane monitoring tasks.

                      HTH

                      Phil

                        Comment

                        • Philip Nelson
                          #7
                          Re: DB2 daily

                          Frank wrote:
                          [color=blue]
                          > Coming from Oracle background:
                          >
                          > How do you carry thiese admin tasks in DB2 Environment :
                          >
                          > Check instance availability
                          > Check listener availability
                          > Check alert log files for error messages
                          > Clean up old log files before log destination gets filled
                          > Analyze tables and indexes for better performance
                          > Check tablespace usage
                          > Find out invalid objects
                          > Monitor users and transactions
                          >
                          >
                          > Thanks for help.[/color]

                          Before getting into writing anything yourself, I'd suggest you check out the
                          "Health Center" (assuming you are on V8). It automates a lot of the
                          mundane monitoring tasks.

                          HTH

                          Phil

                            Comment

                            • Blair Adamache
                              #8
                              Re: DB2 daily

                              There is a new article out today that may help you:

                              http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0404snow/index.html


                              Frank wrote:
                              [color=blue]
                              > Coming from Oracle background:
                              >
                              > How do you carry thiese admin tasks in DB2 Environment :
                              >
                              > Check instance availability
                              > Check listener availability
                              > Check alert log files for error messages
                              > Clean up old log files before log destination gets filled
                              > Analyze tables and indexes for better performance
                              > Check tablespace usage
                              > Find out invalid objects
                              > Monitor users and transactions
                              >
                              >
                              > Thanks for help.[/color]

                                Comment

                                • Blair Adamache
                                  #9
                                  Re: DB2 daily

                                  There is a new article out today that may help you:

                                  http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0404snow/index.html


                                  Frank wrote:
                                  [color=blue]
                                  > Coming from Oracle background:
                                  >
                                  > How do you carry thiese admin tasks in DB2 Environment :
                                  >
                                  > Check instance availability
                                  > Check listener availability
                                  > Check alert log files for error messages
                                  > Clean up old log files before log destination gets filled
                                  > Analyze tables and indexes for better performance
                                  > Check tablespace usage
                                  > Find out invalid objects
                                  > Monitor users and transactions
                                  >
                                  >
                                  > Thanks for help.[/color]

                                    Comment

                                    • Anton Versteeg
                                      #10
                                      Re: DB2 daily



                                      Mark A wrote:[color=blue]
                                      > "Anton Versteeg" <anton_versteeg @nnll.ibm.com> wrote in message
                                      > news:c6ar5v$1q7 m$1@sp15en20.hu rsley.ibm.com.. .
                                      >[color=green]
                                      >>See below for possible commands, etc.
                                      >>Not complete but should get started
                                      >>
                                      >>Frank wrote:
                                      >>[color=darkred]
                                      >>>Coming from Oracle background:
                                      >>>
                                      >>>How do you carry thiese admin tasks in DB2 Environment :
                                      >>>
                                      >>>Check instance availability[/color]
                                      >>
                                      >>connect to instname[/color]
                                      >
                                      >
                                      > Isn't that "attach to instance"?
                                      >
                                      >[/color]

                                      yes

                                      --
                                      Anton Versteeg
                                      IBM Certified DB2 Specialist
                                      IBM Netherlands

                                        Comment

                                        • Anton Versteeg
                                          #11
                                          Re: DB2 daily



                                          Mark A wrote:[color=blue]
                                          > "Anton Versteeg" <anton_versteeg @nnll.ibm.com> wrote in message
                                          > news:c6ar5v$1q7 m$1@sp15en20.hu rsley.ibm.com.. .
                                          >[color=green]
                                          >>See below for possible commands, etc.
                                          >>Not complete but should get started
                                          >>
                                          >>Frank wrote:
                                          >>[color=darkred]
                                          >>>Coming from Oracle background:
                                          >>>
                                          >>>How do you carry thiese admin tasks in DB2 Environment :
                                          >>>
                                          >>>Check instance availability[/color]
                                          >>
                                          >>connect to instname[/color]
                                          >
                                          >
                                          > Isn't that "attach to instance"?
                                          >
                                          >[/color]

                                          yes

                                          --
                                          Anton Versteeg
                                          IBM Certified DB2 Specialist
                                          IBM Netherlands

                                            Comment

                                            Previous template Next
                                            Working...