Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    earth
    Posts
    96

    Post Unanswered: DB2 10.5 BLU-db2convert

    Hello,
    I try to convert a row to column organised table by using the following command.

    db2convert -d sample -z db2inst1 -t table1

    It will always stuck at COPY status and failed to proceed and throw out an error.

    SQL3011C There is not enough storage to process the command. SQLSTATE=HY00

    SQL2448N The db2convert command failed to convert any row-organized tables to column-organized tables.

    All tablespace are using automatic storage and autoresize has been enabled and there are plenty of space. In fact the table1 has no data.

    Thanks in advance for help if anyone has any clue what is went wrong.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    according the doc
    A memory allocation error occurred. Not enough memory ....
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •