Re: Archive query question

2001-04-18 Thread David Longo
Hey Aubrey, Long time, no see! Use this select for a start to see what columns are in ARCHIVES table. select * from syscat.columns where tabname='ARCHIVES' Do the same for tabname='OCCUPANCY' Note: case does matter in select statements. Then you can do a specific select from these tables. Some

Archive query question

2001-04-17 Thread Aubrey Truex
Hey, I would like to query my ADSM server for all objects that are bound to one of my archive copy groups. Is there a command / sql statement I can use to get that kind of output ? (ie. Give me a list of all files that have been archived against archive copygroup PRODUCTION. I would like the