You can use the Database Connection Services (DCS) to specify values that are used to define how an application connects to a database and what database it connects to.
Format: 1-8 single-byte alphanumeric characters, including the number sign (#), at sign (@), dollar sign ($), and underscore (_). It cannot begin with an underscore or a number.
select current server from sysibm.sysdummy1
multiple
LOCATION NAMEs are also defined in the Boot Strap Data Set (BSDS)
as well as the DSNL004I message (LOCATION=location), which is written
when the Distributed Data Facility (DDF) is started. The -DISplay
DDF command could also be used.If accessing a z/OS data sharing group, the domain name should map to the DB2 group dynamic VIPA address. This address routes to the least loaded DB2 member. To access a specific member use the specific DB2 member dynamic VIPA address and turn off sysplex routing. Each member DSNL004I message displays the member specific domain name.
SQL30000N
SQL30040N
SQL30050N
SQL30051N
SQL30053N
SQL30060N
SQL30070N
SQL30071N
SQL30072N
SQL30073N
SQL30074N
SQL30090N
When the disconnect parameter ,D
is not specified, a disconnect will be performed only when the following
SQLCODEs are returned: SQL30020N
SQL30021N
SQL30041N
SQL30061N
SQL30081N
For explanations of these codes, refer to the Message Reference.
If INTERRUPT_ENABLED is configured in the DCS directory at the DB2 Connect workstation, and a client application issues an interrupt while connected to the IBM mainframe database server, DB2 Connect will perform the interrupt by dropping the connection and rolling back the unit of work. This interrupt behavior is supported on AIX®, and Windows.
The application will receive sqlcode (-30081) indicating that the connection to the server has been terminated. The application must then establish a new connection with the IBM Mainframe database server, in order to process additional database requests. On platforms other than AIX V5.2 and later and Windows, DB2 Connect does not support the option of automatically disconnecting when an application using it receives an interrupt request.
catalog TCPIP node nynode remote myhost server myport
catalog dcs database nydb1 as new_york
catalog database nydb1 as newyork1 at node nynode
authentication server
The database alias newyork1 is
to be used for accessing a host database without date transformation
because no date mask has been specified. catalog dcs database nydb2 as new_york
parms \",,,,,,LOCALDATE=\"\"YYYYMMDD\"\"\"
catalog database nydb2 as newyork2 at node nynode
authentication server
The database alias newyork2 gives
you access to the same host database but, in addition, it has a date
format mask specified. This example illustrates that the date format
mask is specified using the keyword LOCALDATE and
is the seventh positional parameter in the PARMS field
of a DCS directory entry. "YYyyMmDd" - Y, M, and D digits are case-insensitive
"MM+DD+YYYY" - OK to have a mask longer than 10 bytes
and to have characters other than Y, M,
and D in the mask
"abcYY+MM" - OK not to have a sequence of D's
The
following date format masks are all invalid date masks: "YYYYyMMDD" - invalid there are 5 Y's in a sequence
"YYYYMDDM" - invalid there are 2 sequences of M's
If
a date format mask is invalid, no error will be issued. It will just
be ignored. Just because a date mask is valid does not mean it will
be used. Date format transformation based on a valid date mask will
only be performed if ALL of the following conditions are true: ",,,,,,,,BIDI=xyz"
where xyz represents
the CCSID override.