Knowledge Center

Benefit: COB

Avoid database triggers on big tables like
STMT.ENTRY,CATEG.ENTRY&
RE.CONSOL.SPEC.ENTRY
0
0
0

A.S. Harish

November 6, 2022

Many best practices have been covered in this document in relation to T24 application servers and oracle db
0
0
1

A.S. Harish

November 6, 2022

EB.STAT.PRINT can be potentially turned off during cob to increase performance
0
0
0

A.S. Harish

November 6, 2022

Some internal system level reports like PROTOCOL etc can be made adhoc in cob to reduce COB time.
0
0
0

A.S. Harish

November 6, 2022

Increase Commit times and reduce database wait times by ensuring Oracle Redo logs are stored in a separate disk
0
0
0

A.S. Harish

November 6, 2022

Analysing AWR oracle reports can help in understanding tables that are queried a lot
0
0
0

A.S. Harish

November 6, 2022

Logging option can be switched off for files with higher IO to increase performance
0
0
0

A.S. Harish

November 6, 2022

TECpack gives us usefull technical information regarding the last working day of the bank.Very useful for performance analysis
0
0
1

A.S. Harish

November 6, 2022

COB.MONITOR,JOB.PROGRESS etc can be used to monitor COB to avoid performance delays and other unexpected crashes
1
1
0

A.S. Harish

November 6, 2022

The main tool for health and performance monitoring in AIX operating system is nmon.This must be used regularly for monitoring health and performance problems in the system
0
0
0

A.S. Harish

November 6, 2022

mw42 is quite a comprehensive command line utility to monitor a bunch of different parameters that can really be useful for performance monitoring
0
0
0

A.S. Harish

November 6, 2022

SHOW.ITEM.LOCKS in TAFC and LOCKS command in TAFJ gives an overview of all the locks held in T24.This is very useful for identifying lock contentions
0
0
0

A.S. Harish

November 6, 2022

loading more results