Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2014
    Posts
    294

    Unanswered: Sqlcode: -1585, sqlstate: 54048

    Hi,

    can some one let me know the solution for this:
    when i am trying to compile a function getting the below error:
    SQLCODE: -1585, SQLSTATE: 54048

    find out some tablespace issue. But unable to resolve as I don't know anything about tablespaces.

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Here are some usefull responses: http://database.ittoolbox.com/groups...-space-1357603

    And you should learn about tablespaces.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    Jul 2014
    Posts
    294
    Thanks Resolved.

    create bufferpool BP2 size 500 pagesize 32K

    CREATE TEMPORARY TABLESPACE TEMPSPACE2 pagesize 32k MANAGED BY DATABASE USING

    (FILE 'C:\DB2\NODE0000\M_AGENT\TEMPSPACE2.TBS' 20M) BUFFERPOOL BP2

Tags for this Thread

Posting Permissions

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