I have used the process to split an archive for one application, it does perform the split. I found I needed to do it twice, once with a positive selection to get the records into an af and once with a negative selection to get the other records into an af file. That left the original af file, and the two subset af files.
I found that the selection criteria was the most difficult thing to get correct, supplying the SQL to select or not select the records.
We have plans to use this further in support of event based retention, when an event happens we split the af file and apply a storage profile to the 'evented' records.
I had examples from 2014 when we did this but my primary group was deleted (so my user home was gone) and the scripts could not be restored. All I can find from that is a parm file with PNS options:
// SPLIT create a PNS driven subset split
OPTIMDIR OPTDIR
AF SERVER1 file2015-05-01_7_05.af
SPLITAF file2015-05-01_7_05_SPLIT.af
DELTAAF file2015-05-01_7_05_DELTA.af
PNS splitIDs.pns
REGISTER SPLIT * GROUP AAA DESC "SPLIT Test PNS"
REGISTER DELTA * GROUP AAA DESC "SPLIT Test PNS"
COLLECTIONS AAA.ALL
RUN ARCHIVESPLIT
Thanks,
Ed Lipson
Managing Director
BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217
Information Lifecycle Management and Database Administration
T 718.315.4763 | F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com
The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.
Please refer to
https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of
www.bnymellon.com.
Original Message------
Hello Keith,
Use the Archive split process, we have used this at multiple customer sites.
https://www.ibm.com/support/knowledgecenter/en/SSMLNW_11.3.0/com.ibm.nex.optimd.dg.doc/13cmdline-maint/oparcuse-r-file_maintenance_split.html
Command file syntax for the Archive Split process is:
[OPTIMDIR optimdirectory]
AF {arcservername | (local)} arcfilename
SPLITAF filename [ SPLITAFX filename]
DELTAAF filename [ DELTAAFX filename]
AD adname | { [ SQL dbalias.cid.tblname sql] [VAR variablename value] [ PNS pnsfile] }
{REGISTER {split | delta}{ (optimdirectory | * ) [GROUP groupidentifier][ DESC description]| NO}
| DELETE }
[COLLECTIONS {split | delta} collection1,...,collectionn]
RUN ARCHIVESPLIT
------------------------------
Vishwas Balakrishna
------------------------------
#InfoSphereOptim
#Optim