DB2 Packages

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

    DB2 Packages

    Hey all.

    I used a backup of an old database to restore it in a new database.
    Since then I get timestamp errors (-818) on bound packages.

    I was wondering, what if I were to drop all the packages (drop all
    results from LIST PACKAGES FOR ALL). What kind of problems would this
    pose for db2? I assume db2 uses a few packages for it's own purposes,
    would these automagically be rebound? Or am I to enormously destroy some
    vital parts of the database (ie the scheduler)?

    Mostly curiousity here, like: if I would hit my laptop with a hammer,
    how severe would the damage be? (I know the answer to this one).

    Thanks.

    -R-
    Tags: None
    • Anton Versteeg via DBMonster.com
      #2
      Re: DB2 Packages

      Did you try to rebind the packages?

      --
      Message posted via http://www.dbmonster.com

        Comment

        • Jurgen Haan
          #3
          Re: DB2 Packages

          Yes, I tried.

          $ db2rbind devdb -l ~/error.log all


          Anton Versteeg via DBMonster.com wrote:[color=blue]
          > Did you try to rebind the packages?
          >[/color]

            Comment

            • Mark A
              #4
              Re: DB2 Packages

              "Jurgen Haan" <jurgen@fake.do m> wrote in message
              news:4231a6e5$0 $43127$e4fe514c @news.xs4all.nl ...[color=blue]
              > Yes, I tried.
              >
              > $ db2rbind devdb -l ~/error.log all
              >[/color]
              If you have your own programs with embedded SQL, you may have to recompile
              them (precompile, compile, bind).


                Comment

                • Jurgen Haan
                  #5
                  Re: DB2 Packages

                  Mark A wrote:
                  [color=blue]
                  > If you have your own programs with embedded SQL, you may have to recompile
                  > them (precompile, compile, bind).[/color]


                  No programs of my own. It's just the packages of DB2 itself.
                  I was wondering what would happen if I were to delete the packages which
                  DB2 created.

                  stuff like this:

                  SQLA1E00 NULLID DB2INST 101 Y 0 CS B
                  SQLA2E00 NULLID DB2INST 106 Y 0 RR B
                  SQLA3E00 NULLID DB2INST 101 Y 0 UR B

                  -R-

                    Comment

                    • EDWARD LIPSON
                      #6
                      Re: DB2 Packages

                      Run the CLI and UBIND bind lists for your database. It sounds like you
                      crossed versions, and each version and fixpack can have new
                      timestamps.

                      the commands like like
                      db2 bind @db2ubind.lst and
                      db2 bind @db2cli.lst.
                      I don't have the full syntax.


                      JH> Yes, I tried.

                      JH> $ db2rbind devdb -l ~/error.log all


                      JH> Anton Versteeg via DBMonster.com wrote:
                      JH> > Did you try to rebind the packages?
                      JH> >

                      Edward Lipson via Relaynet.org Moondog
                      edward.lipson@m oondog.com elipson@bankofn y.com
                      ---
                      þ MM 1.1 #0361 þ


                      ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
                      http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
                      ---= East/West-Coast Server Farms - Total Privacy via Encryption =---

                        Comment

                        Previous template Next
                        Working...