Hi Carlos,
I suggest you to increase the size of the DB too increase the Maximum Reduction to be
greater than 0.
Also, you have the option of reorganize your DB (using UNLOADDB/LOADDB ) but in my
opinion, this option should be done just in case of previous suggestion does not works.
Hope this helps.
Regards,
Rafael
-------
to: CARLOS RAMON BRAVO ARREDONDO <[EMAIL PROTECTED]>
cc:
date: 6/21/2002 9:58:30 PM
subject: problems Query Client Events
> I have problems when trying to execute a Query Client Events.
> The error messages are the following ones.
>
> 19/06/02 11:34:02 ANR2958E SQL temporary table storage has been
> exhausted.
> 19/06/02 11:34:02 ANR9999D hthtml.c(2837): Error 2 received from
> idOpQueryParms.
> 19/06/02 11:34:02 ANR2032E HTML: Command failed - internal server error
> detected.
>
> Server Error
> Interface error encountered in the Hypertext Engine (hthtml.c,2837).
> ANR2032E HTML: Command failed - internal server error detected.
>
>
> Query database
>
> tsm: BSMTSM04>q db f&
>
> Available Space (MB): 2.500
> Assigned Capacity (MB): 2.500
> Maximum Extension (MB): 0
> Maximum Reduction (MB): 0
> Page Size (bytes): 4.096
> Total Usable Pages: 640.000
> Used Pages: 218.454
> Pct Util: 34,1
> Max. Pct Util: 34,1
> Physical Volumes: 5
> Buffer Pool Pages: 512
> Total Buffer Requests: 49.646
> Cache Hit Pct.: 95,50
> Cache Wait Pct.: 0,00
> Backup in Progress?: No
> Type of Backup In Progress:
> Incrementals Since Last Full: 0
> Changed Since Last Backup (MB): 83,78
> Percentage Changed: 9,82
> Last Complete Backup Date/Time: 18/06/02 16:35:29
>
>
> Query log
>
> tsm: BSMTSM04>q log f&
>
> Available Space (MB): 840
> Assigned Capacity (MB): 840
> Maximum Extension (MB): 0
> Maximum Reduction (MB): 832
> Page Size (bytes): 4.096
> Total Usable Pages: 214.528
> Used Pages: 290
> Pct Util: 0,1
> Max. Pct Util: 0,2
> Physical Volumes: 3
> Log Pool Pages: 128
> Log Pool Pct. Util: 0,81
> Log Pool Pct. Wait: 0,00
> Cumulative Consumption (MB): 39.051,00
> Consumption Reset Date/Time: 13/06/01 18:21:23
>
> Filesytem the server
>
> {BSMTSM04:>/}% df -k
> Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
> /dev/hd4 65536 23528 65% 4177 13% /
> /dev/hd2 4128768 864216 80% 65564 7% /usr
> /dev/hd9var 32768 27576 16% 241 3% /var
> /dev/hd3 32768 29020 12% 39 1% /tmp
> /dev/hd1 32768 31624 4% 48 1% /home
> /dev/lv01 17629184 0 100% 26 1% /tsmdata1
> /dev/lv00 14548992 0 100% 24 1% /tsmdata
> /dev/lv03 12025856 0 100% 23 1% /tsmdata2
> /dev/lv02 3014656 1764 100% 24 1% /tsmdb
>
> Does the problem pretend to be in the temporary tables, How can I liberate
> this space?
> your assistance is greatly appreciated.
> Thanks,
>
>
>
> Carlos R. Bravo Arredondo
> [EMAIL PROTECTED]
> Tel. (52) 5551741924
>
_______________________________________________________________________________________________________
Obtin gratis tu cuenta de correo en StarMedia Email. !Regmstrate hoy mismo!.
http://www.starmedia.com/email
