Document Type | Issue Resolution
Category | Interface/Integration
Applicable Product Version | 6FS07
Document Number | TIITS002
Issue
In the previous environment, the DB connection time was 100~200ms, but after migrating the DB in the environment where the cloud region was changed, it increased to 20s, causing service delays.
[Analysis of Phenomenon Environment]
- DB migration was performed using Cold Backup with no changes, so infrastructure verification is necessary
- When running test queries with tbsql in the DB local environment, there were no significant differences in query execution times or plans between the original and migrated DB
- Both the original and migrated environments use the same DB and JDBC Driver versions, and the original DB environment operated without issues, so it is unlikely that DB or Driver versions affect processing speed
- No anomalies found in sys.log
Cause
Due to delays in internal DNS calls within the cloud region, DB connection time increases, resulting in service delays.
Solutions
Maintain the DNS settings of the CSP or create and configure a private DNS within the CSP to resolve the issue.
NoteYou can perform network tests using commands such as traceroute and ping.