sql help - v5 to v6 syntax

2013-10-03 Thread Richard Rhodes
A puzzle for a true db2/sql type person who would like to tackle a v5 to v6 sql problem . . . This does not work on v6. I've played with it for quite some time and can't come up with a v6 version. This is an attempt to identify slow backups that may need attention. These are backup sessions

Re: sql help - v5 to v6 syntax

2013-10-03 Thread Remco Post
check http://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html and the db2 function timestampdiff() Op 3 okt. 2013, om 14:31 heeft Richard Rhodes rrho...@firstenergycorp.com het volgende geschreven: A puzzle for a true db2/sql type person who would like to tackle a v5

Clear DB2-logs

2013-10-03 Thread Hans Christian Riksheim
If I understand correctly there is no way of getting rid of the logs without doing a full dbbackup. Is this a DB2 deficiency or is it TSM(--RFE)? Reason I ask is that when logs are filling up when expiring unnormal amounts of data, automatic dbbackup does not finish in time. Which again is due to

Re: Clear DB2-logs

2013-10-03 Thread Karel Bos
Tried multistream db backs to reduce db backup time? Op 3 okt. 2013 16:39 schreef Hans Christian Riksheim bull...@gmail.com: If I understand correctly there is no way of getting rid of the logs without doing a full dbbackup. Is this a DB2 deficiency or is it TSM(--RFE)? Reason I ask is that

Re: Clear DB2-logs

2013-10-03 Thread Hans Christian Riksheim
Hi, yes we are using multistream but the automatic dbbackup usually kicks off when the server is very busy so throughput is just a fraction compared to daytime when the scheduled dbbackup sets in. Regards, Hans Chr. On Thu, Oct 3, 2013 at 6:11 PM, Karel Bos tsm@gmail.com wrote: Tried