ADM10 – Archiving in T24-R10[1].01.pdf

Welcome to Archiving in T24 learning unit of the T24 Administration Course. In this earn arn ng unt, you w earn earn a out t e arc v ng process n .

ADM10 ADM10 – Archiving Archiving in T24-R10.01 T24-R10.01

1

Trusted by over 1 million members

Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.











After completing this learning unit, you will w ill be able to:

1.

Analy Analyze ze the importa importance nce of arch archivi iving ng data data in T24 T24

2.

Stat State e the the arc archi hiva vall proc proces ess s in T24 T24

3.

Iden Identi tify fy the the impo import rtan ance ce of ARCHIVE application in T24

4.

State State the the advan advantag tage e of the the archiv archival al proces process s in T24 T24











Lots ots of tran trans sacti action ons s coul could d be proce rocess ssed ed on a normal mal worki orking ng day day in a ban bank. When Whene ever you inpu inputt an FT tran transa sact ctio ion, n, stat statem emen entt entr entrie ies s are are gene genera rate ted. d. STMT.ENTRY is the the appl applic icat atio ion n that contains details of all entries over customer and internal accounts. Entries are gene genera rate ted d in this this file file by ever every y on-l on-lin ine e and and batc batch h proc proces ess s whic which h invo involv lves es debi debiti ting ng or cred credit itin ing g Acco ccounts unts.. On a norma ormall worki orking ng day day ther there e coul could d be lot lot of entrie tries s upda update ted d in this this applic plicat atio ion. n. Over a period of time this may occupy a lot space in the database and could be a perf perfor orma manc nce e hind hindra ranc nce. e. In orde orderr to avoi avoid d such such prob proble lems ms data data in thes these e file files s can can be arch archiv ived ed.. 1.

Arch Archiv ivin ing g proc proces ess s remo remove ves s data data from from the the appl applic icat atio ion n and and move moves s it to hist histor oric ic data data

2.

In T24 the archived records are stored in a $ARC file in T24 and it is deleted from the application

3.

The The arch archiv ived ed reco record rds s are are stor stored ed for for futu future re repo report rtin ing g purp purpos ose e











Files to be archived need to have an entry in ARCHIVE application. Lets now look at the e so t e app cat on o n, DESCRIPTION – A general description description is specified in this field Based on what factor are you going to archive the records? Lets say that you are going to archive records based on date, PURGE.DATE –In this field you specify specif y a valid T24 date. Records older than purge date will be archived. RETENTION.PERIOD – If you do not specify specify purge date you you may specify the date in in the RETENTION.PERIOD field. Records older than the retention period will then be archived. Value in this field is specified in the format NNY or NNM where, NN is either a number of months or years. This field is only used if the field PURGE.DATE is null. For example lets say TODAY is 31 March 2010. In RETENTION.PERIOD the value specified is 01M , meaning the records older than 1 February 2010 will be archived. ARCHIVE.DATA – By specifying a value Y here, you tell the system system to archive data in the $ARC files.











Field range ARC.FILENAME to MODULUS are related multi-value fields, which describe the arc ve es w c w e create . FILE.TYPE - When the $ARC file is created, the file type will default to the file type of the live file. However, if a file type is entered here, this will be used in preference. This field is used in older database (Universe) MODULUS - When the $ARC file is created, the modulus of the file will will default to the modulus of the live file. However, if a modulus is entered here, this will be used in preference. Lets say that your live file has 10000 records and you want to archive only 5000 records , based on the number of records you may specify the modulo here. Can you stop the archiving process after a certain number of records are processed? STOP.INDICATOR - When this field is set to Y the archiving process process is halted. This field works in unison with the CHECK.NO.OF.RECS field CHECK.NO.OF.RECS – Here you specify the number of records processed processed each time before STOP.INDICATOR is checked. This field may be changed whilst archival is running and will take effect the next tim e the record is checked. The default value is 1000 records.











Field range COMPANY.RUN.IN to TIME.ENDED are related multi-value fields, which are syste stem popu ate w en arc v ng s run. ey manta manta n a story o eac eac t me arc v ng was run. COMPANY.RUN.IN – The company for which which archival was run. This field is updated updated by T24. TIME.STARTED- Time when the archival archival was started is updated here USER.ID – T24 updates this field with the user id who initiated the archival archival process DATE.SELECTED – PURGE.DATE selected for the archival archival process by the user is updated here STOP.REQUESTED – This field is updated to YES if stop indicator is requested requested by the user else it is updated as NO. RECS.DELETED – Total number of records that were deleted from the main file when archiving is run













The application ARC.GENERIC.REQUEST is used to initiate the actual archiving process . app cat on as on y one recor w t as . . . ARCHIVE.ID – Here you specify a valid ARCHIVE record id. This is a multi-value field hence hence you may archive the other files also. To initiate the archiving process the record in ARC.GENERIC.REQUEST should be verified.











You will now learn the archival process in T24, 1.

Before you start start the archivi archiving ng process, process, ensure ensure that that you take a back-up back-up of the T24 T24 environment.

2. Decide the the file that is to be archive archived. d. Archiving Archiving is run on a set of files in T24. T24. Lets say that you are going to archive the category entries. The archive record for category entries is CATEG.ENTRY. The Files that will be archived are CATEG.ENTRY,CATEG.ENT.ACTIVITY and RE.CONSOL.PROFIT.











Before you archive the records you can take a count on the number of records in all the live es. 1.

Create a VOC to to fetch fetch the record record count count of all the three files namely namely , CATEG.ENT.ACTIVITY, CATEG.ENTRY and RE.CONSOL.PROFIT.

2.

When you you execute execute the VOC you you could see the the total number of records records stored stored in each file.











The archival process is initiated as a service in T24. All the services are defined in applic icat atio ion n and and for for arch archiv ival al proc proces ess s the the reco record rd defi define ned d in TSA.SERVICE is TSA.SERVICE appl BNK/A NK/ARC RC.G .GEN ENER ERIC IC.. The The fiel field d SERV SERVIC ICE. E.CO CONT NTRO ROL L in TSA. TSA.SE SERV RVIC ICE E will ill be set to star startt once you verify the SYSTEM TEM record in ARC.GENERIC.REQUEST. The TSM will request you to manu manual ally ly laun launch ch the the tSA’ tSA’s s once once it is star starte ted d in the the fore foregr grou ound nd mode mode..











Launch the agents in a separate telnet session. Lets now see how the records are archived , The archival files are created under the archive directory. Then the date of the CATEG.E G.ENT.A T.ACTIV TIVITY record is checked ked against the the PURGE.D GE.DA ATE , if the date of the the record is less than the PURGE. GE.DATE then the the record is copied to the $ARC fil file and then it is remo remov ved from from the the main main file file.. Else Else the the reco record rd is retai etaine ned d in the the main main file file.. The

CATEG ENT ACTIVITY records are processed first

then the corresponding























After the archival process is over, check the record count of the $ARC f iles.











The archived records are stored onto the $ARC files. Use the LIST command to view the set











Temenos provides you a set of files that can be archived. Som e of them are





















































































ADM10 – Archiving in T24-R10[1].01.pdf

Recommend Documents