Blogs on Oracle DBA / Temenos T24 - Deepak Kumar

I am recently getting some knowledge in T24 performance tuning. I will share some of my experience from my work while creating reports for APAP * Never put a select blindly on heavily populated tables like ACCOUNT, CUSTOMER etc * Even a medium sized bank have nearly 1 million records in the ACCOUNT table (including the internal accounts.). Blind selects on tables like these will never return. * Index highly queried columns of the most common tables like CUSTOMER, ACCOUNT, CARD/ISSUE etc.. * Make sure you index only the necessary fields only. If you index large number of fields, it will inturn kill the server, as every commit on the table need to update all the indexes. * Its better to use more robust databases like Oracle DB or SQL Server DB as the backend database instead of JBase as they have better performance. * If you are writing a nofile enquiry never do a SSELECT if you need sorted output. Instead finish the processing of the output array and sort the array using the SOR...

The query Language of Jbase is really restrictive. Data analysis and comparison between two table is not possible without the use of spreadsheet software. I recently came to know that Jbase is providing a command called SQLSELECT through which you can actually issue SQL query command directly on Jbase tables. A sample would be like SQLSELECT * FROM FBNK.ACCOUNT WHERE SHORT_NAME LIKE '%PETER%' AND CATEGORY = 6601 Limitations: The command though have serious limitations such as  The table you query should not have dot charecter for example you cannot query FBNK.CUSTOMER.ACCOUNT with this command. But there is a workaround for the above drawback. Make a copy of the VOC record FBNK.CUSTOMER.ACCOUNT into a new one without ID in its ID. For Example: COPY FROM VOC FBNK.CUSTOMER.ACCOUNT,FBNK.CUSACC SQLSELECT * FROM FBNK.CUSACC; will work. The field name should not have dot character. You can overcome this by changing the dot character to underscore. For...