Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    8

    Unanswered: Error while accessing snapshot tables.

    Hi,

    I executed the below statement for get tablespace informations. But, I am getting an error.



    db2 "select tablespace_id,substr(tablespace_name,1,20),total_p ages,used_pages,free_pages from table (snapshot_tbs_cfg('',-1)) as snapshot_tbs order by total_pages desc fetch first 20 rows only"

    SQL1042C An unexpected system error occurred. SQLSTATE=58004

    Please help me in resolving this problem.

    Regards,
    Santhosh

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    ensure that the system time and date is correctly set, and make sure
    your system has enough memory and swapping/paging space
    available.
    Resubmit the current command.
    If the error continues, stop the database manager and restart
    it.
    check more by typing (clp)
    C:\Program Files\IBM\SQLLIB\BIN>db2 ? SQL1042C

    Rahul Singh

Posting Permissions

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