468,257 Members | 1,410 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

Restore not finished

I have a database restore that hasn't finished because it ran into a
problem with not enough memory to complete the restore utility.
However, I cannot update the db cfg to allow enough memory because I
cannot connect to the database because the restore has not completed.
I'm not sure how I'm supposed to fix the memory issue to complete the
restore if I cannot update it until the restore is complete. Any
suggestion would be greatly appreciated. Stupid mistake on my part.
Thanks. Matt

Mar 29 '06 #1
6 1503
In article <11**********************@e56g2000cwe.googlegroups .com>,
ma*******@gmail.com says...
I have a database restore that hasn't finished because it ran into a
problem with not enough memory to complete the restore utility.
However, I cannot update the db cfg to allow enough memory because I
cannot connect to the database because the restore has not completed.
I'm not sure how I'm supposed to fix the memory issue to complete the
restore if I cannot update it until the restore is complete. Any
suggestion would be greatly appreciated. Stupid mistake on my part.
Thanks. Matt


You don't need to connect to the database to change db cfg parms, an
attach to the node/instance it belongs to should be enough.
Mar 29 '06 #2
I can attach to the instance. Then when I try to run the update db cfg
statement, the response is that a database connection does not exist.
Not sure what else to try.

Mar 29 '06 #3
I can attach to the instance. Then when I try to run the update db cfg
statement, the response is that a database connection does not exist.
Not sure what else to try.

Mar 29 '06 #4
In article <11**********************@u72g2000cwu.googlegroups .com>,
ma*******@gmail.com says...
I can attach to the instance. Then when I try to run the update db cfg
statement, the response is that a database connection does not exist.
Not sure what else to try.


You need to specify the DEFERRED option to prevent DB2 from automatic
connecting to the database, check the docs at http://tinyurl.com/h4jby
Mar 29 '06 #5
Gert van der Kooij wrote:
In article <11**********************@u72g2000cwu.googlegroups .com>,
ma*******@gmail.com says...
I can attach to the instance. Then when I try to run the update db cfg
statement, the response is that a database connection does not exist.
Not sure what else to try.


You need to specify the DEFERRED option to prevent DB2 from automatic
connecting to the database, check the docs at http://tinyurl.com/h4jby


I am not sure your udb version and not knowing your exact "memory"
error during restore, see if this works:
db2set DB2_OVERRIDE_BPF=1000 (and bounce the instance)

If your database gets restored successfully, then you can adjust
bufferpool sizes.

Keith Ponnapalli
IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and
Windows
IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration
for UNIX, Linux, Windows and OS/2
INFORMIX Certified 9.2 Database Administrator/4GL Developer

Mar 29 '06 #6
Did you try this?

db2 update db cfg for dbname using xxxx xxxx

To change db cfg, you don't need to connect to a database, you can use
the "for" option.

Mar 30 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by GL | last post: by
11 posts views Thread by Chris | last post: by
2 posts views Thread by Buck Turgidson | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.