Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Monitoring log usage
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... -
RedHat 9.0 and DB2 V8.1
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. -
Logging changes from circular to archive after boot
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... -
page reorgs while updating variable length records
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... -
Stored procedure
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... -
How to transfer DB2 database from Linux server to Win 2000 server ?
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...
