Results 1 to 13 of 13

Thread: file system

  1. #1
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Unanswered: file system

    Hi people,

    I've a big problem, because when i try to do the login of the database(db2 7.2)....i receive the folowing error:
    SQL1004C There is not enough storage on the file system to process the command.

    So what can i do to resolve this problem?
    ..I was trying to delete some files of the drive but i canīt delete more!

    Thanks for your help!

    Rui

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Are you trying to connect to dabase when you receive the error?
    What has filled out your disk?
    Do you have two big log files - decrease them.
    Please tell the reason!

    Please also read the theme Must Read before posting (your subject is bad - would be better if: on connect to database makes file system full)
    http://dbforums.com/t854783.html

    Grofaty

  3. #3
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    on connect to database makes file system full

    Hi,

    Yes, i was trying to connect to database when i receive the error and i receive the same error when i try to connect to another utility of db2.
    I think the problem might be from an procedure that i executed
    yesterday. The procedure will process insert's statments on two tables
    (200 000 lines) and i've done a mistake when i just put the commit after
    processed the 200 000lines.
    I've decreased the log files( 15 files) but the problem continue.
    How can i resolve the problem?

    Thanks,
    Rui


    Originally posted by grofaty
    Hi,

    Are you trying to connect to dabase when you receive the error?
    What has filled out your disk?
    Do you have two big log files - decrease them.
    Please tell the reason!

    Please also read the theme Must Read before posting (your subject is bad - would be better if: on connect to database makes file system full)
    http://dbforums.com/t854783.html

    Grofaty

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: on connect to database makes file system full

    Check your db2diag.log file and admin notification logs(if you are on V8) for information on the filesystem which caused the error ... You can check for the system logs for the information ...

    I reckon the problem is likely to be with your log directory filesystem your db startup may be doing a crash recovery followed by a rollback whcih will require log files ... Please do NOT clear off your log file directory ....

    Cheers

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Re: on connect to database makes file system full

    I Check my db2diag.log file and i extract this comments:



    2003-07-30-16.35.27.345000 InstanceB2CTLSV Node:000
    PID:800(db2syscs.exe) TID:1572 Appid:*LOCAL.DB2CTLSV.030730153343
    data_protection sqlpgrsp Probe:50 DatabaseWCTRLDB

    Log Full -- active log held by appl. handle 8
    End this application by COMMIT, ROLLBACK or FORCE APPLICATION.

    2003-07-30-16.35.27.565000 InstanceB2CTLSV Node:000
    PID:800(db2syscs.exe) TID:1572 Appid:*LOCAL.DB2CTLSV.030730153343
    data_protection sqlpWriteLR Probe:80 DatabaseWCTRLDB
    DIA3609C Log file was full.


    2003-07-30-16.41.28.431000 InstanceB2CTLSV Node:000
    PID:804(db2syscs.exe) TID:912 Appid:none
    common_communication sqlccstrts Probe:1
    DIA3006W Invalid value "DB2SET" specified for DB2COMM environment variable.

    Data Title:unable to free tempary sqlcache stmt PID:804 TID:1520 Node:000
    0000 0000

    2003-07-31-14.27.47.088000 InstanceB2CTLSV Node:000
    PID:1340(db2syscs.exe) TID:1636 Appid:*LOCAL.DB2CTLSV.030731105540
    data_protection sqlpgint Probe:70 DatabaseWCTRLDB
    DIA3612C Disk was full.

    ZRC=FFFFD60C

    2003-07-31-14.27.47.128000 InstanceB2CTLSV Node:000
    PID:1340(db2syscs.exe) TID:1636 Appid:*LOCAL.DB2CTLSV.030731105540
    base_sys_utilities sqledint Probe:5 DatabaseWCTRLDB

    DiagData


    Do you have an idea to resolve the problem?

    Thanks,
    Rui

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: on connect to database makes file system full

    Based on the flow of events and the function name sqlpgint corresponding to the disk full error, I think you need to create more space in the disk where logs are being written ....

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Re: on connect to database makes file system full

    I know but the problem is that my disk is a disk of 5Gb where
    2,54Gb are used and 2,76Gb are free.
    I canīt create more space in the disk because the only thing that i have in my disk is the db2 instalation with the database.


    Originally posted by sathyaram_s
    Based on the flow of events and the function name sqlpgint corresponding to the disk full error, I think you need to create more space in the disk where logs are being written ....

    Cheers
    Sathyaram

  8. #8
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Re: on connect to database makes file system full

    ..the service warehouse logger was stopped..and i start it...now, the disk is full because a big quantity of log files are created...
    Can i resolve that instead adquire another disk?

    Thanks

    Originally posted by rmleite
    I know but the problem is that my disk is a disk of 5Gb where
    2,54Gb are used and 2,76Gb are free.
    I canīt create more space in the disk because the only thing that i have in my disk is the db2 instalation with the database.

  9. #9
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: on connect to database makes file system full

    Under normal circumstances, you can do

    db2 update db cfg using newlogpath <path>

    This will change your logpath to a new directory during the next connect ...

    I'm not sure how db2 will react in your case ... But worth trying ...

    You can give the newlogpath to point to a different disk with more space

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  10. #10
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Re: file system

    Thanks for your help,
    I'll do that.

    Rui


    Originally posted by rmleite
    Hi people,

    I've a big problem, because when i try to do the login of the database(db2 7.2)....i receive the folowing error:
    SQL1004C There is not enough storage on the file system to process the command.

    So what can i do to resolve this problem?
    ..I was trying to delete some files of the drive but i canīt delete more!

    Thanks for your help!

    Rui

  11. #11
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: file system

    My last post should have read

    This will change your logpath to a new directory during the next database activation ...

    instead of

    This will change your logpath to a new directory during the next connect ...

    Sorry about the confusion

    Cheers

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  12. #12
    Join Date
    Jun 2003
    Posts
    127
    If its for connect, sometimes the problem may be due to lack of space in the instance home directory.

  13. #13
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    file system

    Yes, it's exactly a lack of space in the instance home directory....so, if
    i transfer my logpath to another disk..it resolve my problem?
    thanks,
    rui
    Originally posted by Kota
    If its for connect, sometimes the problem may be due to lack of space in the instance home directory.

Posting Permissions

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