2 deleted 77 characters in body; edited tags; edited title
source | link

DB2 tablespace Tablespace error SQLCODE=-289, SQLSTATE=57011

We are trying to bulk insert ~200 million records as initial load into db2a DB2 database.

During the process we get the following error:

SQLCODE=-289, SQLSTATE=57011, SQLERRMC=TEST_IS

SQLCODE=-289, SQLSTATE=57011, SQLERRMC=TEST_IS

Does it mean we ran out of disk space? How to add additional space?

Please find the following details of the tablespace:

it is using Database-managed space. Datatype is large table space, EXTENTSIZE is 32 PAGESIZE is 32768

  • it is a Database-managed space.
  • type is large table space,
  • EXTENTSIZE is 32
  • PAGESIZE is 32768

I am not a DBA and not able to understand the error. Can somebody shed light on proper configuration values for this much larger data set.

Thanks.

DB2 tablespace error SQLCODE=-289, SQLSTATE=57011

We are trying to bulk insert ~200 million records as initial load into db2.

During the process we get the following error

SQLCODE=-289, SQLSTATE=57011, SQLERRMC=TEST_IS

Does it mean we ran out of disk space? How to add additional space?

Please find the following details of the tablespace

it is using Database-managed space. Datatype is large table space, EXTENTSIZE is 32 PAGESIZE is 32768

I am not a DBA and not able to understand the error. Can somebody shed light on proper configuration values for this much larger data set.

Thanks.

Tablespace error SQLCODE=-289, SQLSTATE=57011

We are trying to bulk insert ~200 million records as initial load into a DB2 database.

During the process we get the following error:

SQLCODE=-289, SQLSTATE=57011, SQLERRMC=TEST_IS

Does it mean we ran out of disk space? How to add additional space?

Please find the following details of the tablespace:

  • it is a Database-managed space.
  • type is large table space,
  • EXTENTSIZE is 32
  • PAGESIZE is 32768

I am not a DBA and not able to understand the error.

    Post Migrated Here from stackoverflow.com
1
source | link

DB2 tablespace error SQLCODE=-289, SQLSTATE=57011

We are trying to bulk insert ~200 million records as initial load into db2.

During the process we get the following error

SQLCODE=-289, SQLSTATE=57011, SQLERRMC=TEST_IS

Does it mean we ran out of disk space? How to add additional space?

Please find the following details of the tablespace

it is using Database-managed space. Datatype is large table space, EXTENTSIZE is 32 PAGESIZE is 32768

I am not a DBA and not able to understand the error. Can somebody shed light on proper configuration values for this much larger data set.

Thanks.