Re: Schedule 3rd day of every month
How about scheduling a script with the following code on daily basis. The 3rd every month it will create a onetime-schedule for archiving. Just make sure the syntax for define and delete schedule and association is correct. SELECT DAY(CURRENT_DATE) FROM SYSCAT.TABLES WHERE DAY(CURRENT_DATE)=3 /*can be any table which isn't empty*/ IF (RC_NOTFOUND) GOTO RETRY DEFINE SCHEDULE [YOUR_DOMAINNAME] ARCHIVE_ON_3RD TYPE=CLIENT ACTION=ARCHIVE STARTTIME=NOW+0:30 PERUNITS=ONETIME DEFINE ASSOCIATION [YOUR_DOMAINNAME] ARCHIVE_ON_3RD [YOUR_NODENAME] EXIT RETRY: DELETE SCHEDULE [YOUR_DOMAINNAME] ARCHIVE_ON_3RD EXIT --- Anders Pontusson Exist i Stockholm AB Propellervägen 6b 183 62 Täby Mobile: +46 70 - 399 32 90 Email: [EMAIL PROTECTED] --- Joni Moyer <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-06-02 13:50 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] cc Subject Schedule 3rd day of every month Hello everyone! I was just wondering if anyone would happen to know how to create an admin schedule that will archive a specific servers f:\archive filesystem on the third day of every month for 365 days? I know that I will need an MC of 365 for an archive copy group, but how is it possible to schedule it for the 3rd? Thanks in advance!!! Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
Re: SQL select question
> Does anyone have a way to determine the total amount of files and data > used by a specific file type across the server? In particular, mp3's but > there are other questionable data types. Try this one... However I got no idea if includes just active or both active and inactive files, copypool and so on. SELECT CAST(SUM(FILE_SIZE/1024/1024) AS DECIMAL (1000,0)) AS TOT_MP3_MB FROM CONTENTS WHERE UPPER(FILE_NAME) LIKE '%.MP3' regards, Anders Pontusson
Re: Events table information.
> I am not sure you will be able to do what you want even when you get > the selection criteria sorted out. The events table on our 5.1.7.2 server > does not have a column for completion time. If the same is true on your > server you will probably have to use 'query event' output to compute > durations. I believe that information can be found in the summary table (but then theres no problem with the criterias). SELECT ENTITY AS NODE_NAME,(END_TIME-START_TIME) AS DURATION FROM SUMMARY WHERE UPPER(ACTIVITY)='BACKUP' AND CURRENT_TIMESTAMP-START_TIME<'2 00:00:00' regards, Anders Pontusson
Re: Events table information.
The problem is when selecting from events table it's by default generated with the information of todays date only. Using (CURRENT_TIMESTAMP-SCHEDULED_START<'2 00:00:00') will get information less than two days old within todays info. See the problem? However if you specify a specific date (i.e. '2003-10-25') the events table will be generated from this. There's no limitation in SQL saying you can't use both a specific date and CURRENT_TIMESTAMP at the samt time. I spent hours figuring this out and note that the following workaround will only work for less than 200 years... SELECT * FROM EVENTS WHERE SCHEDULED_START BETWEEN '1970-01-01' AND '2199-12-31' AND CURRENT_TIMESTAMP-SCHEDULED_START<'2 00:00:00' regards, Anders Pontusson