Write failure on DB2 file system when nvme physical disk sector size is 4K.

Solution Verified - Updated -

Issue

  • Write failure on DB2 file system when nvme physical disk sector size is 4K.
  • Error logged at DB2 level while writing to it is -
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
          "Container not accessible"
DATA #1 : <preformatted>
Error acquiring container 3 (/aa/aabbccdd100/db/db06/aabbccdd100/NODE0000/TSMDBXX/X0000000/X00000XX.CAT) for tbsp 0.  Rc = 8402001E
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
  File Handle              = 216
  File System Block Size   = 4096 bytes <<<
  File System Type         = xfs
  Storage Sector Size      = UNKNOWN   <<<

Environment

  • Red Hat Enterprise Linux 8.9
  • IBM DB2
  • Samsung Electronics Co Ltd NVMe SSD Controller (NVME disks)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content