>From my experience at our site, neither. DB2 fails the request and returns a bad SQLCODE.
Bill Bass United HealthCare Senior Applications Developer Greenville, SC -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@listserv.ua.edu] On Behalf Of O'Brien, David W. (NIH/CIT) [C] Sent: Tuesday, June 19, 2012 1:39 PM To: IBM-MAIN@listserv.ua.edu Subject: Migrate DB2 datasets? I noticed that some of my DB2 databases have not been accessed since the turn of the century. These are SMS managed and have a Management class which calls for migration to Level 1 after 365 days of non-use. After another year of non-use they are eligible for ML2. Naturally the Storage Group has auto migrate set to No. Hence my question(s) - If a DB2 table space is migrated, does the entire DB2 environment wait for the recall or just the DB2 user/process which invoked the recall? Does anyone else out there migrate DB2 data? Thank You, Dave O'Brien NIH Contractor ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
