SAP ABAP Class CL_DB2_CONNECTION_POOL (DB2 z/OS: Connnection Factory Pattern)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390
Properties
Class CL_DB2_CONNECTION_POOL  
Short Description DB2 z/OS: Connnection Factory Pattern    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package STU2   CCMS for DB2 for OS/390 
Created 20051125   SAP 
Last change 20130531   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
Class CL_DB2_CONNECTION_POOL has no forward declaration.
Interfaces
Class CL_DB2_CONNECTION_POOL has no interface implemented.
Friends
Class CL_DB2_CONNECTION_POOL has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 CONNECTION_REF Static Attribute Private Object reference (TYPE REF TO) CL_SQL_CONNECTION Database Connection 20051125
2 CON_NAME Static Attribute Private Type reference (TYPE) DBCON-CON_NAME Logical name for a database connection 20051125
3 DBA_NAVIGATOR Instance attribute Private Object reference (TYPE REF TO) CL_DB6_TREE_NAVIGATOR Reference to DBACOCKPIT 20061010
4 SINGLETON_REF Static Attribute Private Object reference (TYPE REF TO) CL_DB2_CONNECTION_POOL Static Reference to Connection Pool 20120806
Methods
# Method Level Visibility Method type Description Created on
1 CLASS_CONSTRUCTOR Static method Public Constructor Initialize the DB2 z/OS connections 20051128
2 CLOSE_CONNECTION Instance method Public Method 20051125
3 GET_COLLECTION_ID Instance method Public Method DB2 for z/OS: Returns the collection id of the connection 20070125
4 GET_CONNECTION Instance method Public Method 20051125
5 GET_CONNECTION_NAME Static method Public Method Returns the connection name 20051128
6 GET_CON_NAME_FROM_DBACOCKPIT Instance method Public Method DB2 z/OS: Returns the connection name form table 'db2misc' 20061010
7 GET_CON_NAME_FROM_MEMORY Instance method Public Method Returns the connection name from memory 20061010
8 GET_CREATOR Static method Public Method Get creator / schema of current connection 20110712
9 GET_DB2_SYSTEM_TYPE Static method Public Method Returns 'DB2' as system type (for future use..) 20060306
10 GET_HOST_NAME Instance method Public Method DB2 for z/OS: Returns the host name of the connection 20070125
11 GET_INSTANCE Static method Public Method 20120806
12 GET_LOCATION Instance method Public Method DB2 for z/OS: Returns the location name of the connection 20070125
13 GET_PORT Instance method Public Method DB2 for z/OS: Returns the port number of the connection 20070125
14 GET_SCHEMA Instance method Public Method DB2 for z/OS: Returns the schema name of the connection 20070125
15 GET_SSID Instance method Public Method DB2 for z/OS: Returns the SSID of the connection 20070126
16 GET_USER Instance method Public Method DB2 for z/OS: Returns the dbcon user of the connection 20081009
17 RELEASE_CONNECTION Instance method Public Method Release Connection received from pool 20120806
18 SET_CONNECTION_NAME Static method Public Method 20051128
Events
Class CL_DB2_CONNECTION_POOL has no event.
Types
Class CL_DB2_CONNECTION_POOL has no local type.
Method Signatures

Method CLASS_CONSTRUCTOR Signature

Method CLASS_CONSTRUCTOR on class CL_DB2_CONNECTION_POOL has no parameter.
Method CLASS_CONSTRUCTOR on class CL_DB2_CONNECTION_POOL has no exception.

Method CLOSE_CONNECTION Signature

Method CLOSE_CONNECTION on class CL_DB2_CONNECTION_POOL has no parameter.
Method CLOSE_CONNECTION on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_COLLECTION_ID Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning COLLECTION_ID Value transfer Type reference (TYPE) STRING 20070125

Method GET_COLLECTION_ID on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_CONNECTION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CON_NAME Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20120806
2 Returning CON_REF Value transfer Object reference (TYPE REF TO) CL_SQL_CONNECTION Datenbankverbindung 20051125
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20120806

Method GET_CONNECTION_NAME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning CON_NAME Value transfer Type reference (TYPE) DBCON-CON_NAME Returns the current active connection name 20051128

Method GET_CONNECTION_NAME on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_CON_NAME_FROM_DBACOCKPIT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning CON_NAME Value transfer Type reference (TYPE) DBCON-CON_NAME 20061010

Method GET_CON_NAME_FROM_DBACOCKPIT on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_CON_NAME_FROM_MEMORY Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning CON_NAME Value transfer Type reference (TYPE) DBCON-CON_NAME 20061010

Method GET_CON_NAME_FROM_MEMORY on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_CREATOR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning CREATOR Value transfer Type reference (TYPE) DB2CREATOR DB2 creator name 20110712
2 Importing REMOTE_DBCON Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20110712
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20110712

Method GET_DB2_SYSTEM_TYPE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning DB2_SYS_TYPE Value transfer Attribute reference (LIKE) SY-DBSYS 20060306

Method GET_DB2_SYSTEM_TYPE on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_HOST_NAME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning HOST Value transfer Type reference (TYPE) STRING 20070125

Method GET_HOST_NAME on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_INSTANCE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning POOL_REF Value transfer Object reference (TYPE REF TO) CL_DB2_CONNECTION_POOL DB2 z/OS: Connnection Factory Pattern 20120806

Method GET_INSTANCE on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_LOCATION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning LOCATION Value transfer Type reference (TYPE) STRING DB2 for z/OS: Returns the location name of the connection 20070125

Method GET_LOCATION on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_PORT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning PORT Value transfer Type reference (TYPE) I DB2 for z/OS: Returns the port number of the connection 20070125

Method GET_PORT on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_SCHEMA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning SCHEMA Value transfer Type reference (TYPE) STRING 20070125

Method GET_SCHEMA on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_SSID Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning SSID Value transfer Type reference (TYPE) STRING 20070126

Method GET_SSID on class CL_DB2_CONNECTION_POOL has no exception.

Method GET_USER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning USER_NAME Value transfer Type reference (TYPE) STRING 20081009

Method GET_USER on class CL_DB2_CONNECTION_POOL has no exception.

Method RELEASE_CONNECTION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CON_REF Call by reference Object reference (TYPE REF TO) CL_SQL_CONNECTION Database Connection 20120806

Method RELEASE_CONNECTION on class CL_DB2_CONNECTION_POOL has no exception.

Method SET_CONNECTION_NAME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing L_CON_NAME Call by reference Type reference (TYPE) DBCON-CON_NAME Logical name for a database connection 20051128

Method SET_CONNECTION_NAME on class CL_DB2_CONNECTION_POOL has no exception.
History
Last changed by/on SAP  20130531 
SAP Release Created in 710