https://www.ibm.com/products/db2
Db2 | IBM
IBM Db2 is the database to run your mission-critical workloads. Power low-latency transactions and real-time analytics across any cloud, hybrid or on-prem.
db2ibm
https://www.softbase.com/
SoftBase Db2 for z/OS Tools
SoftBase is a leading provider of z/OS Db2 application coding, testing and deployment tools. SoftBase provides solutions for Db2 test data masking, Db2 test...
z osdb2tools
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=messages-dsnb797i
Db2 12 - Messages - DSNB797I
OTHER INTERACTIONS REGISTER PAGE = o1 UNREGISTER PAGE = o2 DELETE NAME = o3 READ STORAGE STATISTICS = o4 EXPLICIT CROSS INVALIDATIONS = o5 ASYNCHRONOUS GBP...
db212messages
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=packages-checking-authorization-executing-rrsaf-application-without-plan
Db2 12 - Security - Checking authorization for executing an RRSAF application without a plan
RRSAF provides the capability for an application to connect to Db2 and run without a Db2 plan.
https://www.suse.com/de-de/news-articles/2002/11/sles_db2/
SUSE Linux Enterprise Server Validated for Running the Latest Version of IBM DB2 Database Software
SUSE Linux Enterprise Server Validated for Running the Latest Version of IBM DB2 Database Software
suse linux enterprise server
https://www.ibm.com/docs/en/db2/11.5.x?topic=jdbc-db2sqlca-class
DB2Sqlca class - IBM Db2 11.5
The com.ibm.db2.jcc.DB2Sqlca class is an encapsulation of the SQLCA.
ibm db2class115
https://www.veritas.com/content/support/en_US/doc/16222484-147321455-0/v15491397-147321455
Creating a db2.conf file (vendor method) | Configuring the run-time environment | Configuring...
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=db2-submitting-sql-statements-qmf-workstation
Db2 13 - Introduction - Submitting SQL statements with QMF for Workstation
QMF for Workstation is a tool that helps you build and manage powerful queries without requiring previous experience with SQL.
sql statementsdb213introductionsubmitting
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=tables-creating-created-temporary
Db2 13 - Administration - Creating created temporary tables
If you need a permanent, sharable description of a table but need to store data only for the life of an application process, you can define and use a created...
db213administrationcreatingcreated
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=states-reorg-pending-status
Db2 13 - Utilities - REORG-pending status
REORG-pending status indicates that an object either must or should be reorganized.
db213utilitiesreorgpending
https://www.ibm.com/docs/en/software-hub/5.3.x?topic=s-updating-password-secrets
Updating the Db2 Warehouse password secrets on IBM Software Hub
The Db2 Warehouse administration accounts on your IBM Software Hub cluster are protected by password secrets. During deployment of Db2 Warehouse, these...
db2 warehouseibm softwareupdatingpasswordsecrets
https://www.php.net/manual/de/function.db2-fetch-array.php
PHP: db2_fetch_array - Manual
Returns an array, indexed by column position, representing a row in a result set
phpdb2fetcharraymanual
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=qualifier-changing-your-work-database-new-installation-db2
Db2 12 - Administration - Changing your work database for a new installation of Db2
You can change the high-level qualifier for your work database if you have a new installation of Db2 for z/OS.
your work
https://www.veritas.com/content/support/en_US/doc/16222484-145508604-0/id-SF0A0148251-145508604
Creating DB2 scripts manually | About NetBackup for DB2 templates and shell scripts | Configuring...
creatingdb2scriptsmanually
https://www.gadgets360.com/compare-godrej-8-kg-semi-automatic-top-load-washing-machine-wm-wsedge-ult-80-5-0-db2-m-127822-vs-godrej-6-kg-fully-automatic-front-load-washing-machine-wf-eon-600-pae-14223
Godrej 8 kg Semi Automatic Top Load Washing Machine (WM WSEDGE ULT 80 5.0 DB2 M) vs Godrej 6 kg...
Compare Godrej 8 kg Semi Automatic Top Load Washing Machine (WM WSEDGE ULT 80 5.0 DB2 M) vs Godrej 6 kg Fully Automatic Front Load Washing Machine (WF EON 600...
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=copytocopy-syntax-options-control-statement
Db2 12 - Utilities - Syntax and options of the COPYTOCOPY control statement
The COPYTOCOPY utility control statement, with its multiple options, defines the function that the utility job performs.
of thedb212utilitiessyntax
https://nedb2ug.com/
New England DB2 Users Group |
new englanddb2usersgroup
https://www.ibm.com/docs/en/db2/12.1.x?topic=uninstalling-db2-connect-windows
Uninstalling Db2 Connect (Windows)
This task provides steps for completely removing your Db2 database product from your Windows operating system. Only perform this task if you no longer require...
uninstallingdb2connectwindows
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnj139i
Db2 13 - Messages - DSNJ139I
LOG OFFLOAD TASK ENDED
db213messages
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=access-use-views-control
Db2 13 - Introduction - Use of views to control access
The table privileges DELETE, INSERT, SELECT, and UPDATE can also be granted on a view. By creating a view and granting privileges on it, you can give an ID...
db213introductionuseviews
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnu330i
Db2 13 - Messages - DSNU330I
csect-name TABLESPACE IS NOT EMPTY
db213messages
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=functions-sqlsetcursorname-set-cursor-name
Db2 13 - ODBC - SQLSetCursorName() - Set cursor name
SQLSetCursorName() associates a cursor name with the statement handle. This function is optional because Db2 ODBC implicitly generates a cursor name when each...
db213odbcsetcursor
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnu1172i
Db2 13 - Messages - DSNU1172I
csect-name- KEY EVALUATION ERROR OCCURRED DURING PROCESSING AT RID rid-value INDEX = index-name TABLE = table-name RECNO= input-dataset-record-number for-part...
db213messages
https://www.php.net/manual/it/function.db2-fetch-assoc.php
PHP: db2_fetch_assoc - Manual
Returns an array, indexed by column name, representing a row in a result set
phpdb2fetchassocmanual
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnu618i
Db2 13 - Messages - DSNU618I
csect-name SYSINDEXPART CATALOG STATISTICS FOR index-name PARTITION part-number
db213messages
https://www.ibm.com/docs/en/db2/11.5.x?topic=steps-node-tests
Node tests in Db2 XQuery
A node test is a condition that must be true for each node that is selected by an axis step. The node test can be expressed as either a name test or a kind...
nodetestsdb2xquery
https://www.php.net/manual/de/function.db2-primary-keys.php
PHP: db2_primary_keys - Manual
Returns a result set listing primary keys for a table
primary keysphpdb2manual
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=programming-differences-between-java-routines-other-routines
Db2 13 - Java - Differences between Java routines and other routines
Java routines differ in a few basic ways from routines that are written in other programming languages.
db213javadifferencesroutines
https://www.ibm.com/docs/en/db2/12.1.x?topic=uddwhd-upgrading-external-etcd-store-created-db2-db2-warehouse-etcd-image
Upgrading the external etcd store created with the Db2 or Db2 Warehouse etcd image
You can upgrade the external etcd store to use the latest etcd image packaged with Db2.
created withupgradingexternaletcdstore
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=buryd-removing-various-pending-states-from-lob-xml-table-spaces
Db2 12 - Administration - Removing various pending states from LOB and XML table spaces
You can remove various pending states from a LOB table space or an XML table space by using a collection of utilities in a specific order.
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=copy-make-copies-xml-schema-repository-objects
Db2 13 - Utilities - Make copies of XML schema repository objects
Although the XML schema repository is not part of the Db2 catalog, you need to create backup copies of XML schema repository table spaces when you back up...
xml schemadb213utilitiesmake
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=authorities-defining-resource-names-administrative
Db2 13 - RACF - Defining resource names for administrative authorities
The RACF access control module builds the resource names for administrative authorities based on the classification model you selected.
db213racfdefiningresource
https://www.ibm.com/docs/en/idr/11.4.0?topic=luw-cdc-replication-engine-db2-database-metadata-tables
CDC Replication Engine for Db2 Database metadata tables
CDC Replication maintains a set of metadata tables that represent data about your current replication configuration.
cdc replicationengine fordb2 databasemetadatatables
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=tablespace-reorganizing-catalog-directory
Db2 13 - Utilities - Reorganizing the catalog and directory
You can run REORG TABLESPACE on the table spaces in the catalog database (DSNDB06) and on the SCT02, SPT01, DBD01, SYSLGRNX, SYSDBDXA, SYSSPUXA, SYSSPUXB, and...
the catalogdb213utilitiesreorganizing
https://www.ibm.com/docs/en/db2/11.5.x?topic=functions-boolean-function
boolean function (Db2 XQuery)
The fn:boolean function returns the effective Boolean value of a sequence.
boolean functiondb2xquery
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnj159i
Db2 13 - Messages - DSNJ159I
csect-name ACTIVE LOG DATA SET DSN=dsname IS GREATER THAN 768 GB IN SIZE
db213messages
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=statement-options-that-are-ignored-by-db2
Db2 13 - Installation and migration - Options that are ignored by Db2
Some options for VTAM APPL statements are not applicable to Db2. Do not code these options in your APPL statement.
db213installationmigrationoptions
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=jsri-jdbc-differences-between-versions-data-server-driver-jdbc-sqlj
Db2 13 - Java - JDBC differences between versions of the IBM Data Server Driver for JDBC and SQLJ
Before you can upgrade your JDBC applications from older to newer versions of the IBM Data Server Driver for JDBC and SQLJ, you need to understand the...
https://www.manageengine.com/products/desktop-central/patch-management/DB2-patches.html
DB2 Updates | ManageEngine Desktop Central
Desktop Central is a Windows Desktop Management Software for managing desktops in LAN and across WAN from a central location. It provides Software Deployment,...
db2updatesmanageenginedesktopcentral
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=coprocessor-pli-pp-compiler-option
Db2 13 - Internationalization - PL/I PP compiler option
When you specify the CCSID for a PL/I application, you might need to use the PP compiler option. This option enables you to specify SQL processing options to...
pl idb213internationalizationpp
https://www.spec.org/jenterprise2010/results/res2010q1/jEnterprise2010-20100210-00005.html
SPECjEnterprise2010 Result: WebSphere Application Server V7 on IBM System x3650 and DB2 9.7 on IBM...
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnu066i
Db2 13 - Messages - DSNU066I
csect-name OPERAND oooooo NOT ALLOWED FOR uuuuuu UTILITY against tttttt TABLE
db213messages
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnu061i
Db2 13 - Messages - DSNU061I
csect-name USER user-id NOT AUTHORIZED, UTILID=util-id
db213messages
https://www.ibm.com/docs/en/idr/11.4.0?topic=gcfsdi-performing-outer-join-using-getcol-function-db2-i
Performing an outer join using the %GETCOL function (Db2 for i)
An example of how to perform an outer join using the %GETCOL function and the CDC Replication Engine for Db2 for i.
outer joinperformingusing
https://www.ibm.com/docs/en/db2/11.5.x?topic=ladsudm-using-databasemetadata-extensions-identify-db2-connect-version-data-server-driver-jdbc-sqlj-version
Using DatabaseMetaData extensions to identify the Db2 Connect version and the IBM Data Server...
The DB2DatabaseMetaData.getDriverDB2ConnectLevel method identifies the version of Db2 Connect and the IBM Data Server Driver for JDBC and SQLJ version that an...
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=saic-dsntej5c
Db2 13 - Application programming and SQL - DSNTEJ5C
THIS JCL PERFORMS THE PHASE 5 SETUP FOR THE SAMPLE APPLICATIONS AT SITES WITH COBOL.
application programmingdb213sql
https://www.php.net/manual/uk/function.db2-field-num.php
PHP: db2_field_num - Manual
Returns the position of the named column in a result set
phpdb2fieldnummanual
https://www.ibm.com/docs/en/spectrum-symphony/7.3.2?topic=database-configuring-loader-controller-linux-kerberos-enabled-db2
Configuring the loader controller on Linux for Kerberos-enabled DB2
Configuring the loader controller on a Linux host with IBM Spectrum Symphony Advanced Edition for a Kerberos-enabled IBM DB2 database server involves...
configuringloadercontrollerlinuxkerberos
https://www.ibm.com/docs/en/db2/12.1.x?topic=replication-in-db2-containerized-deployments
Replication in Db2 for containerized deployments
Using shell scripts, you can setup replication from Db2 common container to Db2 Red Hat OpenShift and Kubernetes or Db2 on Cloud Pak for Data.
replicationdb2containerizeddeployments
https://www.ibm.com/docs/en/db2/11.5.x?topic=compatibility-data-types
IBM PureData System for Analytics (Netezza) and Db2 data type compatibility
Netezza and Db2 databases share a large common set of data types. To learn about data type incompatibilities and how to manage them when migrating from a...
ibm puredatasystemanalytics
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=panel-group-attach-field-ssid-decp-value
Db2 13 - Installation and migration - GROUP ATTACH field (SSID DECP value)
The value of the GROUP ATTACH field specifies a generic group attachment name. This name is to be used for batch programs, the call attachment facility (CAF),...
db213installationmigration
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=programs-db2-object-relational-extensions
Db2 12 - Application programming and SQL - Db2 object relational extensions
With the object extensions of Db2, you can incorporate object-oriented concepts and methodologies into your relational database by extending Db2 with richer...
application programmingobject relationaldb212sql
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=environment-deferring-recovery-during-restart
Db2 13 - Data sharing - Deferring recovery during restart
It is possible to defer recovery for an object during restart. If you use the DEFER installation option, that defers the log apply processing of the object for...
data sharingdb213deferringrecovery
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnt511i
Db2 13 - Messages - DSNT511I
FIELDS 2 AND 5 MUST BE UNIQUE FOR EACH NEW MEMBER INSTALLED
db213messages
https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=2F9034D0653611E982882C5D069DA07A&osPlatforms=AIX&duComponentIds=S002%7CS003%7CS004%7CS006%7CS007%7CA001%7CA005%7CA008
Db2 Advanced Edition VPC Option 11.5.0.0 - Detailed System Requirements
advanced edition11 5db2vpcoption
https://www.veritas.com/content/support/en_US/doc/16222484-145508604-0/v99402633-145508604
BLI incremental backup options using NetBackup for DB2 | About configuring NetBackup for DB2...
incremental backupblioptionsusingnetbackup
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=messages-dsnt216i
Db2 12 - Messages - DSNT216I
REBIND FOR PACKAGE = package-name FAILED BECAUSE AT LEAST ONE BIND OPTION SPECIFIED CANNOT BE CHANGED IN CONJUNCTION WITH PLANMGMT.
db212messages
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=recover-running-redirected-recovery
Db2 12 - Utilities - Running a redirected recovery
A redirected recovery is when the RECOVER utility redirects the recovery of an object (the source) to another object (the target). Specifically, the target...
db212utilitiesrunningredirected
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=messages-dsnl024i
Db2 12 - Messages - DSNL024I
DDF IS ALREADY IN THE PROCESS OF STOPPING
db212messages
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=explain-direct-row-access-primary-accesstyped
Db2 13 - Performance - Direct row access (PRIMARY_ACCESSTYPE='D')
If an application selects a row from a table that contains a ROWID column, the row ID value implicitly contains the location of the row. If you use that row ID...
db213performancedirectrow
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=messages-dsna319i
Db2 12 - Messages - DSNA319I
stored-procedure RECEIVED UNKNOWN FUNCTION func-name
db212messages
https://spec.org/jenterprise2018web/results/res2018q4/jEnterprise2018web-20180926-00003.html
SPECjEnterprise2018 Web Profile Result: WebSphere Liberty Core 18.0.0.3 on Cisco C240 M5 and DB2...
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=statements-defining-sql-descriptor-areas-sqlda-in-cobol
Db2 13 - Application programming and SQL - Defining SQL descriptor areas (SQLDA) in COBOL
If your program includes certain SQL statements, you must define at least one SQL descriptor area (SQLDA). Depending on the context in which it is used, the...
application programming
https://www.ibm.com/docs/en/db2/11.5.x?topic=functions-false-function
false function (Db2 XQuery)
The fn:false function returns the xs:boolean value false.
falsefunctiondb2xquery
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=functions-fnseconds-from-datetime-function
Db2 13 - pureXML guide - fn:seconds-from-dateTime function
The fn:seconds-from-dateTime function returns the seconds component of an xs:dateTime value that is in its localized form.
db213purexmlguidefn
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=queries-using-scrollable-cursors-efficiently
Db2 13 - Performance - Using scrollable cursors efficiently
Scrollable cursors are a valuable tool for writing applications such as screen-based applications, in which the result table is small and you often move back...
db213performanceusingcursors
https://www.php.net/manual/en/function.db2-fetch-assoc.php
PHP: db2_fetch_assoc - Manual
Returns an array, indexed by column name, representing a row in a result set
phpdb2fetchassocmanual
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=reference-sequence-privileges
Db2 13 - RACF - Sequence privileges
db213racfsequenceprivileges
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnb467i
Db2 13 - Messages - DSNB467I
STATISTICS FOR object-type database-name.space-name INSTANCE instance-number DATA SET #: set-number USE COUNT: application-count
db213messages
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=release-in-memory-buffer-pools
Db2 12 - What's new - In-memory contiguous buffer pools
In Db2 12, you can assign objects to in-memory buffer pools. The data pages for the object remain in the buffer pool if they can fit within the size of the...
what s newin memorydb212contiguous
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=states-refresh-pending-status
Db2 12 - Utilities - REFRESH-pending status
When Db2 marks an object in REFRESH-pending (REFP) status, it also puts the object in RECOVER-pending (RECP) or REBUILD-pending (RBDP or PSRBD) status.
db212utilitiesrefreshpending
https://www.veritas.com/content/support/en_US/doc/16222484-147321455-0/v15492315-147321455
RESTORE DATABASE command options | Using DB2 to perform a restore | Performing a database restore |...
restoredatabasecommandoptionsusing
https://www.ibm.com/docs/en/dqmfz/3.4.0?topic=monitor-copying-db2-entries
Copying Db2 entries
You can copy associated and not associated Db2 entries to other Db2 entries or to new Db2 entries.
copyingdb2entries
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=definitions-dclgen-declarations-generator
Db2 13 - Application programming and SQL - DCLGEN (declarations generator)
Your program should declare the tables and views that it accesses. The Db2 declarations generator, DCLGEN, produces these DECLARE statements for C, COBOL, and...
application programmingdb213sqldeclarations
https://www.veritas.com/content/support/en_US/doc/16222484-147321455-0/v15490653-147321455
About NetBackup for DB2 with Snapshot Client operations | Using Snapshot Client with NetBackup for...
netbackupdb2snapshotclientoperations
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=odbc-external-contexts
Db2 13 - ODBC - External contexts
Typically, the Db2 ODBC driver manages contexts in an ODBC application. With external contexts, you can write applications that manage contexts outside of Db2...
db213odbcexternalcontexts
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=zos-where-spatial-data-comes-from
Db2 Accessories Suite V4 - Spatial support - Where spatial data comes from
You can obtain spatial data by generating it from spatial functions and importing it from external sources.
db2accessoriessuitev4spatial
https://www.php.net/manual/it/function.db2-foreign-keys.php
PHP: db2_foreign_keys - Manual
Returns a result set listing the foreign keys for a table
foreign keysphpdb2manual
https://www.ibm.com/docs/es/software-hub/5.3.x?topic=db2-uninstalling
Desinstalar Db2 desde IBM Software Hub
Un administrador de instancias puede desinstalar Db2.
ibm softwaredesinstalardb2desdehub
https://www.ibm.com/docs/en/zos/3.1.0?topic=services-using-db2-cc-precompiler
Using the DB2 C/C++ precompiler
usingdb2c
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=procedures-data-types-in-stored
Db2 13 - Application programming and SQL - Data types in stored procedures
A stored procedure that is written in any language except REXX must declare each parameter that is passed to it. The definition for that stored procedure must...
sql data typesapplication programmingdb213
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=db2-get-message
Db2 13 - Db2 SQL - GET_MESSAGE stored procedure
The GET_MESSAGE stored procedure returns the short message text for an SQLCODE.
db213sqlgetmessage
https://www.ibm.com/docs/en/ims/15.1.0?topic=facility-preparing-your-system-use-db2-attach
IMS 15 - Communications and connections - Preparing your system to use the DB2 Attach Facility
To prepare your system to use the DB2 Attach Facility, you must perform two tasks.
https://www.suse.com/pt-br/news-articles/2002/11/sles_db2/
SUSE Linux Enterprise Server Validated for Running the Latest Version of IBM DB2 Database Software
SUSE Linux Enterprise Server Validated for Running the Latest Version of IBM DB2 Database Software
suse linux enterprise server
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=parameters-st-distance
Db2 Accessories Suite V4 - Spatial support - ST_Distance
ST_Distance takes two geometries and, optionally, a unit as input parameters and returns the shortest distance between any point in the first geometry to any...
db2accessoriessuitev4spatial
https://www.php.net/manual/tr/function.db2-result.php
PHP: db2_result - Manual
Returns a single column from a row in the result set
phpdb2resultmanual
https://www.ibm.com/docs/en/db2/12.1.x?topic=pitddsw-changing-default-db2-default-database-client-interface-copy-after-installation-windows
Changing the default Db2 and default IBM database client interface copy after installation (Windows)
The db2swtch command can be run from any Db2 copy or IBM data server driver copy.
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=commands-modify-irlmprocpurge-zos-irlm
Db2 12 - Commands - MODIFY irlmproc,PURGE command (z/OS IRLM)
The MODIFY irlmproc,PURGE command releases IRLM locks retained due to a Db2, IRLM, or system failure.
command zdb212commandsmodify
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnb526i
Db2 13 - Messages - DSNB526I
DWQT FOR bpname HAS BEEN SET TO integer
db213messages
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=tables-dsn-profile-attributes-history
Db2 13 - Performance - SYSIBM.DSN_PROFILE_ATTRIBUTES_HISTORY profile table
The profile attributes history table, DSN_PROFILE_ATTRIBUTES_HISTORY, contains the attributes that were in effect at some point in time. The schema is SYSIBM.
profile attributesdb213performancedsn
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=messages-dsnu039i
Db2 12 - Messages - DSNU039I
csect-name - LRECL=0 FOR DDNAME dd-name
db212messages
https://www.ibm.com/docs/en/db2/11.5.x?topic=information-sqlj-iterator-conversion-clause
SQLJ iterator-conversion-clause - IBM Db2 11.5
The iterator conversion clause converts a JDBC ResultSet to an iterator.
ibm db2sqljiteratorconversionclause
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnh090i
Db2 13 - Messages - DSNH090I
S csectname LINE nnnn COL cc HOST VARIABLE NOT PERMITTED HERE: name
db213messages
https://www.spec.org/jenterprise2010/results/res2010q1/jEnterprise2010-20091207-00003.html
SPECjEnterprise2010 Result: WebSphere Application Server V7 on IBM BladeCenter and DB2 9.7 on IBM...
websphere application server
https://www.ibm.com/docs/en/cloud-paks/cp-data/5.3.x?topic=virtualization-customizing-audit-policies
Customizing an audit policy in Db2 audit facility for Data Virtualization
You can customize default Db2 audit facility configurations for Data Virtualization.
an auditfor datacustomizingpolicydb2
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=functions-changes-datetime-data-types
Db2 13 - ODBC - Changes to datetime data types
The ODBC driver supports both ODBC 2.0 and ODBC 3.0 datetime values for input. For output, the ODBC driver determines the value to return based on the setting...
db213odbcchangesdatetime
https://www.slideserve.com/hidi/best-practices-in-db2-security
PPT - Best Practices in DB2 Security PowerPoint Presentation, free download - ID:296198
DB2 9 Security Update. Best Practices in DB2 Security. Jim Pickel, STSM pickel@us.ibm.com. Session Agenda. Security Challenges New Security Features Best...
best practices
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=messages-dsnu1199i
Db2 13 - Messages - DSNU1199I
db213messages
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=facilities-db2-security-solutions
Db2 13 - Security - Db2 security solutions
With each new release, Db2 gets faster and more secure.
db213securitysolutions
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=elements-authorization-ids-roles-authorization-names
Db2 13 - Db2 SQL - Authorization IDs, roles, and authorization names
Processes can successfully execute SQL statements only if they have the necessary authority. A process derives this authority from its authorization IDs. An...
db213sqlauthorizationids