Professional Web Applications Themes

Not enough storage available to PCKCACHE?? - IBM DB2

trying to delete a store from websphere's database steps are: db2 delete from store where store_id = 10051 db2 delete from storeent where storeent_id = 10051 results: [db2inst1ca db2inst1]$ db2 delete from store where store_id = 10051 DB20000I The SQL command completed successfully [db2inst1ca db2inst1]$ db2 delete from storeent where storeent_id = 10051 DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0973N Not enough storage is available in the "PCKCACHE" heap to process the statement. SQLSTATE=57011 how do i increase the heap size? tia...

  1. #1

    Default Not enough storage available to PCKCACHE??

    trying to delete a store from websphere's database
    steps are:

    db2 delete from store where store_id = 10051
    db2 delete from storeent where storeent_id = 10051

    results:
    [db2inst1ca db2inst1]$ db2 delete from store where store_id = 10051
    DB20000I The SQL command completed successfully

    [db2inst1ca db2inst1]$ db2 delete from storeent where storeent_id = 10051
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0973N Not enough storage is available in the "PCKCACHE" heap to process
    the statement. SQLSTATE=57011

    how do i increase the heap size?

    tia
    Stuart H Guest

  2. #2

    Default Re: Not enough storage available to PCKCACHE??

    Update the PCKCACHESZ parameter using the UPDATE DATABASE CONFIGURATION
    command or the Control Centre.
    "Stuart H" <postto_group.com> wrote in message
    news:pan.2003.09.15.16.31.09.982173to_group.com.. .
    > trying to delete a store from websphere's database
    > steps are:
    >
    > db2 delete from store where store_id = 10051
    > db2 delete from storeent where storeent_id = 10051
    >
    > results:
    > [db2inst1ca db2inst1]$ db2 delete from store where store_id = 10051
    > DB20000I The SQL command completed successfully
    >
    > [db2inst1ca db2inst1]$ db2 delete from storeent where storeent_id = 10051
    > DB21034E The command was processed as an SQL statement because it was not
    a
    > valid Command Line Processor command. During SQL processing it returned:
    > SQL0973N Not enough storage is available in the "PCKCACHE" heap to
    process
    > the statement. SQLSTATE=57011
    >
    > how do i increase the heap size?
    >
    > tia

    Mark Yudkin Guest

Similar Threads

  1. Form Storage
    By Seth in forum MySQL
    Replies: 3
    Last Post: August 10th, 03:49 AM
  2. HTML storage
    By MidiBot@gmail.com in forum MySQL
    Replies: 4
    Last Post: July 9th, 11:04 PM
  3. OT: Portable Storage
    By Paul G Elson in forum Adobe Photoshop Mac CS, CS2 & CS3
    Replies: 0
    Last Post: April 9th, 04:18 PM
  4. Not enough server storage
    By Dick S in forum Windows Networking
    Replies: 3
    Last Post: July 5th, 08:52 PM
  5. XP Pro Net thru VPN - Not enough server storage...
    By Rush in forum Windows Networking
    Replies: 3
    Last Post: July 3rd, 05:56 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139