IBM Support

DTK Installation Error: SQL0293N Error accessing a table space container on Debian VM

Troubleshooting


Problem

During the installation of the Developer Toolkit (DTK) on a Debian VM, the om-compose.sh setup process encounters an issue and gets stuck. 

Symptom

The following error stack is observed:

User: db2inst1
Driver: com.ibm.db2.jcc.DB2Driver
URL: jdbc:db2://db2server:50000/OMDB
16:51:20.374 [main] ERROR SecurityLogger - 000310100002 UTIL.FRAME_JDBC.ERR_ConnectionFactory_create null
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][4.33.31] The application server rejected establishment of the connection.
An attempt was made to access a database, OMDB, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004

Additionally, the db2server container logs display the following errors:

SQL0293N Error accessing a table space container. SQLSTATE=57048
OMDB restored....
SQL1013N The database alias name or database name "OMDB" could not be found. SQLSTATE=42705

Cause

The issue is caused by the lack of support for storage devices that use a 4K sector size. The DB2_4K_DEVICE_SUPPORT environment variable is not set to ON, which is necessary to adjust the memory layout of data structures and the parameters of disk I/O operations to be compatible with this type of storage.

Diagnosing The Problem

To diagnose the problem, follow these steps:

  1. Check the Console Errors:

    • Review the console logs for errors related to the JDBC connection. Specifically, look for DisconnectNonTransientConnectionException and ERRORCODE=-4499, SQLSTATE=08004.

  2. Review the db2server Container Logs:

    • Inspect the logs for errors such as SQL0293N and SQL1013N, which indicate issues with accessing the table space container and the database alias name or database name not being found.

  3. Verify the DB2_4K_DEVICE_SUPPORT Setting:

    • Check if the DB2_4K_DEVICE_SUPPORT environment variable is set to ON in the devtoolkit_docker/compose/docker/db2server/create_database.sh file.

Resolving The Problem

To resolve the issue, add the following lines to the devtoolkit_docker/compose/docker/db2server/create_database.sh file where the error is coming from:

db2set DB2_4K_DEVICE_SUPPORT=ON
db2stop
db2start
image-20250922110104-1


This setting enables support for storage devices that use a 4K sector size, adjusting the memory layout of data structures and the parameters of disk I/O operations to be compatible with the requirements of this type of storage.

After making these changes, the setup process should work correctly.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSGTJF","label":"IBM Sterling Order Management System"},"ARM Category":[{"code":"a8m0z000000cxzWAAQ","label":"Install and Deploy"}],"ARM Case Number":"TS020193616","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":""}]

Product Synonym

sterling;oms;dtk

Document Information

Modified date:
22 September 2025

UID

ibm17245540

Page Feedback