SPS
Construction of U2L conversion of main computer system
Cloud deployment and U2L business performance improvement/tuning
In order to respond to the increase in online transactions at Gwangju Bank and the discontinuation of sales and technical support for manufacturers' products, LGCNS is replacing the Unix-based main computer system with a Linux-based main computer system. In order to prepare for and support various variables such as changes in the operating platform of Gwangju Bank's account system and changes in the DB operating environment, LGCNS adopted and applied OpenPOP SPS, which has been verified by Jeonbuk Bank's next generation, Suhyup Bank's DW advancement, and Hana Bank's next generation, and is checking/comparing/analyzing/improving changes in SQL performance in advance and supporting the guarantee of stable performance of DB/SQL in the new DB environment.
The solution
Selecting SQL change targets according to DB Version (19C) Upgrade
Full check of SQL execution errors in 19C environment
Support for SQL performance comparison verification and performance optimization in the current operating DB (11g) and new operating DB (19c) environments
Early performance verification of APP/SQL on new operating DB
SQL Performance Optimization Process and Performance/History Management