IBM Support

SQL1042C error during database creation on a file system with Block Size or Sector Size greater than 512 bytes

Troubleshooting


Problem

Create database command fails with SQL1042C on a file system defined with a Block Size or Sector Size greater than 512 bytes.

Symptom

If you have a file system defined with a Block Size (BSZ) or a Sector Size (SSZ) greater than 512 bytes, then the create database command will fail with SQL1042C and the following error message will be generated in the db2diag.log : :
2013-04-18-12.55.54.397808-240 E23451E1100         LEVEL: Error (OS)
PID     : 25747                TID  : 140737115055872PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : TEST
EDUID   : 19                   EDUNAME: db2loggr (TEST) 0
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"
         DIA8501C A buffer pool logic error has occurred.
CALLED  : OS, -, open                             OSERR: EINVAL (22)
DATA #1 : Codepath, 8 bytes
4:11:15:20:22:37
DATA #2 : File name, 62 bytes
/db2/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/S0000002.LOG
DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes
SQLO_REVISE, SQLO_READWRITE, SQLO_SHAREREAD, SQLO_WRITETHRU, SQLO_SECTOR_ALIGNED, SQLO_NO_THREAD_LEVEL_FILE_LOCK
DATA #4 : Hex integer, 4 bytes
0x00000180
DATA #5 : signed integer, 4 bytes
0
DATA #6 : signed integer, 4 bytes
16384
DATA #7 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.

2013-04-18-12.55.54.398406-240 I24552E455          LEVEL: Error
PID     : 25747                TID  : 140737115055872PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : TEST
EDUID   : 19                   EDUNAME: db2loggr (TEST) 0
FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:220
RETCODE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"
         DIA8501C A buffer pool logic error has occurred.

2013-04-18-12.55.54.398515-240 I25008E691          LEVEL: Error
PID     : 25747                TID  : 140737115055872PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : TEST
EDUID   : 19                   EDUNAME: db2loggr (TEST) 0
FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:220
MESSAGE : Filename :
DATA #1 : Hexdump, 62 bytes
0x00007FFFE9BFC830 : 2F64 6232 2F64 6232 696E 7374 312F 6462    /db2/db2inst1/db
0x00007FFFE9BFC840 : 3269 6E73 7431 2F4E 4F44 4530 3030 302F    2inst1/NODE0000/
0x00007FFFE9BFC850 : 5351 4C30 3030 3031 2F53 514C 4F47 4449    SQL00001/SQLOGDI
0x00007FFFE9BFC860 : 522F 5330 3030 3030 3032 2E4C 4F47         R/S0000002.LOG

2013-04-18-12.55.54.398597-240 I25700E381          LEVEL: Error
PID     : 25747                TID  : 140737115055872PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : TEST
EDUID   : 19                   EDUNAME: db2loggr (TEST) 0
FUNCTION: DB2 UDB, data protection services, sqlpgole, probe:1710
MESSAGE : Error -2029060094 opening database log extent 2:

2013-04-18-12.55.54.398638-240 I26082E456          LEVEL: Error
PID     : 25747                TID  : 140737115055872PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : TEST
EDUID   : 19                   EDUNAME: db2loggr (TEST) 0
FUNCTION: DB2 UDB, data protection services, sqlpgicl, probe:1390
RETCODE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"
         DIA8501C A buffer pool logic error has occurred.

2013-04-18-12.55.54.398798-240 I26539E462          LEVEL: Error
PID     : 25747                TID  : 140737115055872PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : TEST
EDUID   : 19                   EDUNAME: db2loggr (TEST) 0
FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInit, probe:1150
RETCODE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"
         DIA8501C A buffer pool logic error has occurred.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"Database Objects\/Config - Database","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.7;9.5;10.1;10.5;11.1;","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

link to actual document

Document Information

More support for:
Db2 for Linux, UNIX and Windows

Software version:
9.7, 9.5, 10.1, 10.5, 11.1,

Operating system(s):
AIX, HP-UX, Linux, Solaris

Document number:
490517

Modified date:
01 May 2025

UID

swg21635111

Manage My Notification Subscriptions

Page Feedback