Results 1 to 2 of 2

Thread: sql state=57011

  1. #1
    Join Date
    Jul 2007
    Posts
    6

    Red face Unanswered: sql state=57011

    Hi,

    Today I got a problem with new table insertion in data base. Presently we are using linux os, and on that db2 7.2.5.

    Today I want a table creation through import command. like


    import from vstr4 of ixf create into bill_master


    then the out put is . -964 error database log full. can not create the table.

    error code 57011 . this is practiced on remote server., i am not having x windows.

    i want this problem, how to control thru command line.

    i want syntax for this problem control. plz help me.

    Thanks & Regards

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    what you could do is specifying commitcount
    import from file of ixf commitcount 1000 create into ....
    or create the table yourself and do alter table xx not logged initially - import.. insert into tablename
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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