network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 3 months |
| seen | May 8 at 20:32 | |
| stats | profile views | 21 |
|
Apr 8 |
revised |
ORACLE restore - how to restore specific .bkp file? added 236 characters in body |
|
Apr 8 |
asked | ORACLE restore - how to restore specific .bkp file? |
|
Apr 4 |
awarded | Popular Question |
|
Feb 27 |
comment |
Is storing archive logs on local disk and backups on vendor storage possible? Oooouh OK. So it will start filling ACTIVE LOG PATH. For the worst scenario - what will happen if that location after some time is also full??? And also how is calculated size of ACTIVE LOGS (similar to LOGFILSIZ*LOGPRIMARY for ARCHIVE LOGS)? Thank you |
|
Feb 27 |
comment |
Is storing archive logs on local disk and backups on vendor storage possible? When 2GB is fulfilled. DB2 will try to use the FAILARCHPATH. I do not have this defined. If I do not set AUTO_DEL_REC_OBJ setting what will happen? Will I get some error (out of space ) or DB2 will insert in archive logs new transations while previous will be deleted? |
|
Feb 27 |
comment |
Is storing archive logs on local disk and backups on vendor storage possible? OK so archive logs size is calculated with this: LOGFILSIZ*LOGPRIMARY equals on example 2GB. |
|
Feb 27 |
comment |
Is storing archive logs on local disk and backups on vendor storage possible? Hello Chris it is totally clear now. If I may my last (unfortunately very begginer's) question-- is the maximum size of archive logs determined or not? On example if I turn archive logging on 1st January can there be a risk that I get out of storage space on local disk??? What steps should I take to prevent that I get out of storage if number of logs is just keep bigger and their number is also bigger and bigger? Thank you and sorry for this simple question |
|
Feb 27 |
accepted | Is storing archive logs on local disk and backups on vendor storage possible? |
|
Feb 26 |
comment |
Is storing archive logs on local disk and backups on vendor storage possible? Hi Chris thanks as always. I don't get the point of LOGARCHMETH2 paramter. What is it for? If both LOGARCHMETH are different from OFF logs will be written in both locations? Am I right? OK that wasn't what I thoght. By your answer you said I could have on different devices backups and archive logs so that is clear for me. Or I MUST(!!!) have LOGARCHMETH2 set if I want backup on different location (device)? thank you |
|
Feb 26 |
asked | Is storing archive logs on local disk and backups on vendor storage possible? |
|
Feb 26 |
comment |
DB2 Online Restore but Without Roll Forward? ok thank you. all the best |
|
Feb 25 |
accepted | Online backups with VENDOR library: what should be set for ACTIVE LOG PATH? |
|
Feb 25 |
comment |
DB2 Online Restore but Without Roll Forward? I don't know what number to suggest them..if you don't know nevemind thank you anyway |
|
Feb 25 |
comment |
DB2 Online Restore but Without Roll Forward? Hi Chris. Thank you. I meant on OPEN num-sessions SESSIONS on backup command publib.boulder.ibm.com/infocenter/db2luw/v9r5/… |
|
Feb 24 |
comment |
DB2 online restore - “SQL1035N The database is currently in use.” Yes it is actively being used. |
|
Feb 24 |
asked | DB2 online restore - “SQL1035N The database is currently in use.” |
|
Feb 24 |
asked | Online backups with VENDOR library: what should be set for ACTIVE LOG PATH? |
|
Feb 24 |
comment |
DB2 Online Restore but Without Roll Forward? Also please sorry but for changing from CIRUCLLAR to ARCHIVE logging I set LOGARCHMETH1 paramter to location of VENDOR:....so64 etc (library file). That is for archive logging. What path shoud I set for active logging? on example my LOGARCHEMTH1 is set to LOGARCHMETH1=VENDOR:/usr/openv/netbackup/bin/nbdb2.sl64 waht value should have ACTIVE LOG parameter? on local disk or also on some VENDOR location? what does it depends on? |
|
Feb 24 |
comment |
DB2 Online Restore but Without Roll Forward? How can I calculate value for OPEN SESSIONS? thank you |
|
Feb 24 |
comment |
DB2 Online Restore but Without Roll Forward? Thank you Chris this is great. You are real db2 guru! Ny customer will use Veritas NetBackup tool so we will use VENDOR option in LOGARCHMETH1 parametere. Tell me how to know what is the optimal number for OPEN SESSIONS option? My customer is asking me for recommended number but I do not know |
