By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

Restore not finished

P: n/a
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
Share this Question
Share on Google+
6 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.