000016866 - AxM - What aserver/eserver uses to determine that a connection is good upon startup

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000016866
Applies ToRSA Access Manager 6.x
Access Manager uses the select query to validate the connection during the startup.
SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2
IssueAxM - What aserver/eserver uses to determine that a connection is good upon startup
During the startup, does aserver do any "data" validation to make sure the connections are good before fully starting up?
NotesEnable DAL_PROFILE and DAL_CONN debug facilities and found below query is used to validate the connection.

RSA Access Manager Entitlements Server
Version 6.2 (Hotfix 6.2.0.01)
Copyright (c) 2013 EMC Corporation. All Rights Reserved.
# RSA Access Manager Entitlements Server
# Version  : 6.2 (Hotfix 6.2.0.01)
# Build ID : 20130321051501-0400-1359432
#
# Date     : Tue Apr 16 14:27:22 IST 2013
# Java     : 1.7.0_17 (VM 23.7-b01) / 32-bit / Oracle Corporation
# System   : INENTHANGPL1C@10.30.95.38, running Windows 7 6.1 on x86
#
# Active Debug Facilities: [dal_conn, dal_profile]
#
Bootstrap at Tue Apr 16 14:27:22 IST 2013

Loading configuration:
        eserver.conf ... done.
        sql.conf ... done.
Validating license: done.
Seeding random number generator: done.
Starting logs:
        Local file appender ... done.
Intializing cache flush listener (update delay is 0 seconds): done.
Automatic cache flushes are enabled.
Initializing sirrus.da.sql.admin.factory.SQLFactory data source:
Starting connection(s) to SQL:
        mssql ... 14:27:23:838 [dal_conn] [main] - Attempting to open connection.
14:27:25:860 [dal_conn] [main] - Attempting to validate ...
14:27:25:861 [dal_conn] [main] -   Executing query: SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2
14:27:26:501 [dal_profile] [main] - , 574," SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2 "
14:27:26:511 [dal_conn] [main] -   Result: 0
14:27:26:511 [dal_conn] [main] - Valid. Time in ms = 640
14:27:26:512 [dal_conn] [main] - Opened.
14:27:26:513 [dal_conn] [main] - Returned connection. Now free = 1, leased = 0
14:27:26:514 [dal_conn] [main] - Attempting to open connection.
14:27:26:621 [dal_conn] [main] - Attempting to validate ...
14:27:26:624 [dal_conn] [main] -   Executing query: SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2
14:27:26:628 [dal_profile] [main] - , 0," SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2 "
14:27:26:629 [dal_conn] [main] -   Result: 0
14:27:26:629 [dal_conn] [main] - Valid. Time in ms = 5
14:27:26:629 [dal_conn] [main] - Opened.
14:27:26:630 [dal_conn] [main] - Returned connection. Now free = 2, leased = 0
14:27:26:630 [dal_conn] [main] - Attempting to open connection.
14:27:26:661 [dal_conn] [main] - Attempting to validate ...
14:27:26:669 [dal_conn] [main] -   Executing query: SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2
14:27:26:671 [dal_profile] [main] - , 1," SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2 "
14:27:26:672 [dal_conn] [main] -   Result: 0
14:27:26:673 [dal_conn] [main] - Valid. Time in ms = 3
14:27:26:690 [dal_conn] [main] - Opened.
14:27:26:693 [dal_conn] [main] - Returned connection. Now free = 3, leased = 0
14:27:26:693 [dal_conn] [main] - Attempting to open connection.
14:27:26:747 [dal_conn] [main] - Attempting to validate ...
14:27:26:759 [dal_conn] [main] -   Executing query: SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2
14:27:26:762 [dal_profile] [main] - , 2," SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2 "
14:27:26:763 [dal_conn] [main] -   Result: 0
14:27:26:763 [dal_conn] [main] - Valid. Time in ms = 4
14:27:26:764 [dal_conn] [main] - Opened.
14:27:26:764 [dal_conn] [main] - Returned connection. Now free = 4, leased = 0
14:27:26:764 [dal_conn] [main] - Attempting to open connection.
14:27:26:783 [dal_conn] [main] - Attempting to validate ...
14:27:26:784 [dal_conn] [main] -   Executing query: SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2
14:27:26:789 [dal_profile] [main] - , 2," SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2 "
14:27:26:823 [dal_conn] [main] -   Result: 0
14:27:26:837 [dal_conn] [main] - Valid. Time in ms = 39
14:27:26:842 [dal_conn] [main] - Opened.
14:27:26:847 [dal_conn] [main] - Returned connection. Now free = 5, leased = 0
14:27:26:847 [dal_conn] [main] - Attempting to open connection.
14:27:26:881 [dal_conn] [main] - Attempting to validate ...
14:27:26:881 [dal_conn] [main] -   Executing query: SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2
14:27:26:893 [dal_profile] [main] - , 1," SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2 "
14:27:26:908 [dal_conn] [main] -   Result: 0
14:27:26:925 [dal_conn] [main] - Valid. Time in ms = 27
14:27:26:943 [dal_conn] [main] - Opened.
14:27:26:958 [dal_conn] [main] - Returned connection. Now free = 6, leased = 0
14:27:26:976 [dal_conn] [main] - Attempting to open connection.
14:27:27:027 [dal_conn] [main] - Attempting to validate ...
14:27:27:041 [dal_conn] [main] -   Executing query: SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2
14:27:27:061 [dal_profile] [main] - , 1," SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2 "
14:27:27:077 [dal_conn] [main] -   Result: 0
14:27:27:095 [dal_conn] [main] - Valid. Time in ms = 36
14:27:27:099 [dal_conn] [main] - Opened.
14:27:27:100 [dal_conn] [main] - Returned connection. Now free = 7, leased = 0
14:27:27:100 [dal_conn] [main] - Attempting to open connection.
14:27:27:134 [dal_conn] [main] - Attempting to validate ...
14:27:27:142 [dal_conn] [main] -   Executing query: SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2
14:27:27:181 [dal_profile] [main] - , 11," SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2 "
14:27:27:188 [dal_conn] [main] -   Result: 0
14:27:27:193 [dal_conn] [main] - Valid. Time in ms = 46
14:27:27:197 [dal_conn] [main] - Opened.
14:27:27:198 [dal_conn] [main] - Returned connection. Now free = 8, leased = 0
14:27:27:200 [dal_conn] [main] - Attempting to open connection.
14:27:27:303 [dal_conn] [main] - Attempting to validate ...
14:27:27:313 [dal_conn] [main] -   Executing query: SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2
14:27:27:325 [dal_profile] [main] - , 12," SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2 "
14:27:27:328 [dal_conn] [main] -   Result: 0
14:27:27:329 [dal_conn] [main] - Valid. Time in ms = 15
14:27:27:329 [dal_conn] [main] - Opened.
14:27:27:330 [dal_conn] [main] - Returned connection. Now free = 9, leased = 0
14:27:27:330 [dal_conn] [main] - Attempting to open connection.
14:27:27:432 [dal_conn] [main] - Attempting to validate ...
14:27:27:434 [dal_conn] [main] -   Executing query: SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2
14:27:27:439 [dal_profile] [main] - , 4," SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2 "
14:27:27:442 [dal_conn] [main] -   Result: 0
14:27:27:442 [dal_conn] [main] - Valid. Time in ms = 8
14:27:27:444 [dal_conn] [main] - Opened.
14:27:27:446 [dal_conn] [main] - Returned connection. Now free = 10, leased = 0
14:27:27:449 [dal_conn] [main] - Connection watcher started w/ period = 300000
14:27:27:450 [dal_conn] [main] - Got leased connection. Now free = 9, leased = 1
14:27:27:460 [dal_conn] [main] - Returned connection. Now free = 10, leased = 0
started.
Done.
14:27:27:478 [dal_conn] [main] - Got leased connection. Now free = 9, leased = 1
14:27:30:287 [dal_profile] [main] - , 2679," UPDATE NEXT_KEY SET NEXT_KEY = NEXT_KEY + 1000 "
14:27:30:414 [dal_profile] [main] - , 127," SELECT NEXT_KEY FROM NEXT_KEY "
14:27:30:579 [dal_conn] [main] - Returned connection. Now free = 10, leased = 0
Legacy Article IDa61242

Attachments

    Outcomes