Search results for query: *

Answer to all three is NO. But here are some notes - When you take a backup then information is written to the history file, and can be retrieved with the LIST HISTORY command, about what logfiles are needed to allow recovery from that point. This can serve as a useful guideline about what...

Not at this time : there are problems with the POSIX-compliant libraries I'm told. It's expected that this will be fixed in Fixpack 4, due Q3 (although IBM haven't promised this). Meanwhile stick to RH 8.

Remember that changes to DBM CFG parameters don't become effective until the DB2 instance is stopped and started (and that a reboot obviously does this). So in all probability the change is happening sometime prior to the reboot. Because the value has changed to CAPTURE rather than RECOVERY I...

I don't believe you can explicitly : there is no DB or DBM CFG parameter to do this. The reason why you are getting page reorgs is because DB2 is "repacking" the data on the page because the data being written back is a different length to that read. Is this causing you a major...

I assume you are trying to create this in SPUFI ? The problem is that you are using the default character to identify the end of an SQL statement (a semicolon). Because the SQL stored procedure contains multiple "SQL statements" within it, when it hits the first semicolon it takes...

The question is "Why would you want to ?" The answer to your query is the db2move command (look it up in the manual). You cannot restore a backup from one platform onto another platform (in general). Certain UNIX systems are similar enough that this will work, but between Windows...