DB2 Packages

[Jurgen Haan]

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-

[Anton Versteeg via DBMonster.com]

Did you try to rebind the packages?

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

[Jurgen Haan]

Yes, I tried.

$ db2rbind devdb -l ~/error.log all
Anton Versteeg via DBMonster.com wrote:

Did you try to rebind the packages?

[Mark A]

"Jurgen Haan" <ju****@fake.dom> wrote in message
news:42***********************@news.xs4all.nl...

Yes, I tried.

$ db2rbind devdb -l ~/error.log all

If you have your own programs with embedded SQL, you may have to recompile
them (precompile, compile, bind).

[Jurgen Haan]

Mark A wrote:

If you have your own programs with embedded SQL, you may have to recompile
them (precompile, compile, bind).

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-

[EDWARD LIPSON]

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
ed***********@moondog.com el*****@bankofny.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 =---