Posts
Actual screenshots from operation in action :
The log table structure :
help qep_abf_log
Name: qep_abf_log
Owner: psnouser
Created: 24/06/2008 09:05:56
Type: user table
Version: II2.5
Column Information:
Column Name Type Length Nulls Defaults Seq
application char 10 no no
dbuser char 10 no no
terminal char 60 no no
entrydate date no no
querytext char 200 no no
errortext char 200 no no
An entry in the table (executing an insert into table (values) select from table1 where...) :
|grk |psuser |/dev/ttyp3 |12/10/2008 12:09:00 |insert into esk300devttyp3 (am_asq, d_kin, c_eid, c_grn) select kin.am_asq, kin.d_kin, kin.c_eid,c_grn=kin.c_grn_pr from kin, mas where mas.am_asq=kin ... |E_QE0203 The estimated number of IO requests to run this query (3982)\n exceeds the IO limit (1000) established for this session. \n The query is aborted with a fatal l error.\n (Wed Jun 25 12:08:44|
Another entry in the table (executing a simple select) :
|grk |psnouser |/dev/ttyp0 |14/10/2008 06:37:00 |select table_name as h_table from iicolumns where (table_owner='psuser' and table_name='esk2520devttyp0' ) |E_QE0203 The estimated number of IO requests to run this query (12)\n exceeds the IO l imit (10) established for this session. \n The query is aborted with a fatal error.\n (Tue Oct 14 06:36:56 |
| Trapped Form |  |
| Exception caught (Admittedly scary message for the user!Not exactly what I was taught once upon a time in the HCI class!!) |  |
| Action cancelled |  |
The log table structure :
help qep_abf_log
Name: qep_abf_log
Owner: psnouser
Created: 24/06/2008 09:05:56
Type: user table
Version: II2.5
Column Information:
Column Name Type Length Nulls Defaults Seq
application char 10 no no
dbuser char 10 no no
terminal char 60 no no
entrydate date no no
querytext char 200 no no
errortext char 200 no no
An entry in the table (executing an insert into table (values) select from table1 where...) :
|grk |psuser |/dev/ttyp3 |12/10/2008 12:09:00 |insert into esk300devttyp3 (am_asq, d_kin, c_eid, c_grn) select kin.am_asq, kin.d_kin, kin.c_eid,c_grn=kin.c_grn_pr from kin, mas where mas.am_asq=kin ... |E_QE0203 The estimated number of IO requests to run this query (3982)\n exceeds the IO limit (1000) established for this session. \n The query is aborted with a fatal l error.\n (Wed Jun 25 12:08:44|
Another entry in the table (executing a simple select) :
|grk |psnouser |/dev/ttyp0 |14/10/2008 06:37:00 |select table_name as h_table from iicolumns where (table_owner='psuser' and table_name='esk2520devttyp0' ) |E_QE0203 The estimated number of IO requests to run this query (12)\n exceeds the IO l imit (10) established for this session. \n The query is aborted with a fatal error.\n (Tue Oct 14 06:36:56 |
Comments