That output show you don't have the same problem as me in the first
chunk. Did you see the error log in your Operating System?
[]'s,
T*** Systems do Brasil Ltda
Alberto Romeu Pessonio Filho
IBM Informix Certified System Administrator V7
IBM Certified Managing and Optimizing Informix Databases V7
DBA Informix/DB2 UDB/SQLServer/Oracle
F: 55+11-4347-5475 / 2184-2751
email: alberto.pessonio@ts3.com.br
Internet: www.t-systems.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de LEY
PATRICK
Enviada em: quarta-feira, 25 de Fevereiro de 2009 3:35
Para: ids@iiug.org
Assunto: Re: RES: I/O bad request chunk 0 [15017]
Hi Alberto Pessonio,
>From the command oncheck -pe it shown that there are still free space
>at
rootdbs.
Snip of the oncheck -pe command:
DBspace Usage Report: rootdbs Owner: informix Created: 08/09/2007
Chunk Pathname Size Used Free
1 /apps/informix/ids.93/databases/rootdbs 1045000 852975 192025
Description Offset Size
------------------------------------------------------------- --------
--------
RESERVED PAGES 0 12
CHUNK FREELIST PAGE 12 1
rootdbs:'informix'.TBLSpace 13 250
stores_demo:'informix'.systables 263 8
stores_demo:'informix'.syscolumns 271 16 stores_demo:'superuser'. 100_1
287 4 FREE 291 2 RESERVED PAGES 293 4 RESERVED PAGES 297 4
stores_demo:'informix'.sysindices 301 24
stores_demo:'informix'.systabauth 325 16
stores_demo:'informix'.syscolauth 341 8 stores_demo:'informix'.sysviews
349 8 stores_demo:'informix'.sysusers 357 8
stores_demo:'informix'.sysdepend 365 8
stores_demo:'informix'.syssynonyms 373 8
stores_demo:'informix'.syssyntable 381 8
stores_demo:'informix'.sysconstraints 389 8
stores_demo:'informix'.sysreferences 397 8
stores_demo:'informix'.syschecks 405 8
stores_demo:'informix'.sysdefaults 413 8
stores_demo:'informix'.syscoldepend 421 8
stores_demo:'informix'.sysprocedures 429 8
stores_demo:'informix'.sysprocbody 437 8
stores_demo:'informix'.sysprocplan 445 8
stores_demo:'informix'.sysprocauth 453 8 stores_demo:'informix'.sysblobs
461 8 stores_demo:'informix'.sysopclstr 469 8
stores_demo:'informix'.systriggers 477 8
stores_demo:'informix'.systrigbody 485 8
stores_demo:'informix'.sysdistrib 493 8
stores_demo:'informix'.sysfragments 501 8
stores_demo:'informix'.sysfragauth 509 8
stores_demo:'informix'.sysxtdtypes 517 8
stores_demo:'informix'.sysxtddesc 525 8
stores_demo:'informix'.sysattrtypes 533 8
stores_demo:'informix'.sysinherits 541 8
stores_demo:'informix'.syscolattribs 549 8
stores_demo:'informix'.syslogmap 557 8 stores_demo:'informix'.syscasts
565 24 stores_demo:'informix'.sysxtdtypeauth 589 8
stores_demo:'informix'.sysams 597 8 stores_demo:'informix'.systabamdata
605 8 stores_demo:'informix'.sysopclasses 613 8
stores_demo:'informix'.syserrors 621 8
stores_demo:'informix'.systraceclasses 629 8
stores_demo:'informix'.systracemsgs 637 8
stores_demo:'informix'.sysroutinelangs 645 8
stores_demo:'informix'.syslangauth 653 8 FREE 661 186
stores_demo:'informix'.sysaggregates 847 8
stores_demo:'informix'.sysroleauth 855 8
stores_demo:'informix'.sysobjstate 863 8
stores_demo:'informix'.sysviolations 871 8
stores_demo:'informix'.systables 879 8
stores_demo:'informix'.sysprocbody 887 16
stores_demo:'informix'.sysprocedures 903 8
stores_demo:'informix'.sysprocbody 911 8
stores_demo:'informix'.sysprocauth 919 8
stores_demo:'informix'.sysprocbody 927 16
stores_demo:'informix'.sysprocedures 943 8
stores_demo:'informix'.sysprocbody 951 32
stores_demo:'informix'.sysprocedures 983 8
stores_demo:'informix'.sysprocbody 991 24
stores_demo:'informix'.sysprocauth 1015 8
stores_demo:'informix'.sysprocedures 1023 8
stores_demo:'informix'.sysprocbody 1031 24
stores_demo:'informix'.sysprocedures 1055 8
stores_demo:'informix'.sysprocbody 1063 32
stores_demo:'informix'.sysprocedures 1095 8
stores_demo:'informix'.sysprocauth 1103 8
stores_demo:'informix'.sysprocbody 1111 16
stores_demo:'informix'.sysprocplan 1127 8
stores_demo:'superuser'.customer 1135 8 stores_demo:'superuser'.orders
1143 8 stores_demo:'superuser'. 101_3 1151 4 stores_demo:'superuser'.
101_4 1155 4 stores_demo:'informix'.syscolumns 1159 8
stores_demo:'superuser'.manufact 1167 8 stores_demo:'superuser'. 102_7
1175 4 stores_demo:'superuser'.stock 1179 8 stores_demo:'superuser'.
103_8 1187 4 stores_demo:'superuser'. 103_9 1191 4
stores_demo:'superuser'.items 1195 8 stores_demo:'superuser'. 104_10
1203 6 stores_demo:'superuser'. 104_11 1209 4 stores_demo:'superuser'.
104_12 1213 4 stores_demo:'informix'.sysindices 1217 8
stores_demo:'superuser'.state 1225 8 stores_demo:'superuser'. 105_16
1233 5 stores_demo:'superuser'.call_type 1238 8 stores_demo:'superuser'.
106_17 1246 4 stores_demo:'superuser'.cust_calls 1250 8
stores_demo:'superuser'. 107_18 1258 4 stores_demo:'superuser'. 107_19
1262 4 stores_demo:'superuser'. 107_20 1266 4
stores_demo:'superuser'.zip_ix 1270 4 stores_demo:'superuser'.catalog
1274 8 stores_demo:'superuser'. 108_21 1282 4 stores_demo:'superuser'.
108_22 1286 4 stores_demo:'superuser'.catalog 1290 8 FREE 1298 198
LOGICAL LOG: Log file 21 1496 50000 LOGICAL LOG: Log file 22 51496 50000
FREE 101496 212 RESERVED PAGES 101708 107 RESERVED PAGES 101815 107 FREE
101922 13341 sysmaster:'informix'.sysdatabases 115263 4
sysmaster:'informix'.systables 115267 8 sysmaster:'informix'.syscolumns
115275 16 sysmaster:'informix'.sysindices 115291 24
sysmaster:'informix'.systabauth 115315 16
sysmaster:'informix'.syscolauth 115331 8 sysmaster:'informix'.sysviews
115339 8 sysmaster:'informix'.sysusers 115347 8
sysmaster:'informix'.sysdepend 115355 8 sysmaster:'informix'.syssynonyms
115363 8 sysmaster:'informix'.syssyntable 115371 8
sysmaster:'informix'.sysconstraints 115379 8
sysmaster:'informix'.sysreferences 115387 8
sysmaster:'informix'.syschecks 115395 8 sysmaster:'informix'.sysdefaults
115403 8 sysmaster:'informix'.syscoldepend 115411 8
sysmaster:'informix'.sysprocedures 115419 8
sysmaster:'informix'.sysprocbody 115427 8
sysmaster:'informix'.sysprocplan 115435 8
sysmaster:'informix'.sysprocauth 115443 8 sysmaster:'informix'.sysblobs
115451 8 sysmaster:'informix'.sysopclstr 115459 8
sysmaster:'informix'.systriggers 115467 8
sysmaster:'informix'.systrigbody 115475 8
sysmaster:'informix'.sysdistrib 115483 8
sysmaster:'informix'.sysfragments 115491 8
sysmaster:'informix'.sysfragauth 115499 8
sysmaster:'informix'.sysxtdtypes 115507 8
sysmaster:'informix'.sysxtddesc 115515 8
sysmaster:'informix'.sysattrtypes 115523 8
sysmaster:'informix'.sysinherits 115531 8
sysmaster:'informix'.syscolattribs 115539 8
sysmaster:'informix'.syslogmap 115547 8 sysmaster:'informix'.syscasts
115555 24 sysmaster:'informix'.sysxtdtypeauth 115579 8
sysmaster:'informix'.sysams 115587 8 sysmaster:'informix'.systabamdata
115595 8 sysmaster:'informix'.sysopclasses 115603 8
sysmaster:'informix'.syserrors 115611 8
sysmaster:'informix'.systraceclasses 115619 8
sysmaster:'informix'.systracemsgs 115627 8
sysmaster:'informix'.sysroutinelangs 115635 8
sysmaster:'informix'.syslangauth 115643 8
sysmaster:'informix'.sysaggregates 115651 8
sysmaster:'informix'.sysroleauth 115659 8
sysmaster:'informix'.sysobjstate 115667 8
sysmaster:'informix'.sysviolations 115675 8
sysmaster:'informix'.systables 115683 8 sysmaster:'informix'.sysprocbody
115691 16 sysmaster:'informix'.sysprocedures 115707 8
sysmaster:'informix'.sysprocbody 115715 8
sysmaster:'informix'.sysprocauth 115723 8
sysmaster:'informix'.sysprocbody 115731 16
sysmaster:'informix'.sysprocedures 115747 8
sysmaster:'informix'.sysprocbody 115755 32
sysmaster:'informix'.sysprocedures 115787 8
sysmaster:'informix'.sysprocbody 115795 24
sysmaster:'informix'.sysprocauth 115819 8
sysmaster:'informix'.sysprocedures 115827 8
sysmaster:'informix'.sysprocbody 115835 24
sysmaster:'informix'.sysprocedures 115859 8
sysmaster:'informix'.sysprocbody 115867 32
sysmaster:'informix'.sysprocedures 115899 8
sysmaster:'informix'.sysprocauth 115907 8
sysmaster:'informix'.sysprocbody 115915 16
sysmaster:'informix'.sysprocplan 115931 8
sysmaster:'informix'.syscolumns 115939 8 sysmaster:'informix'.systabauth
115947 8 sysmaster:'informix'.flags_text 115955 8
sysmaster:'informix'.flags_text_ix1 115963 12
sysmaster:'informix'.flags_text 115975 8 FREE 115983 2
sysmaster:'informix'.syscolumns 115985 8
sysmaster:'informix'.flags_text_ix1 115993 12
sysmaster:'informix'.flags_text 116005 8
sysmaster:'informix'.flags_text_ix1 116013 12
sysmaster:'informix'.smi_build_status 116025 8
sysmaster:'informix'.logmessage 116033 8
sysmaster:'informix'.sysprocbody 116041 8
sysmaster:'informix'.syscolumns 116049 8 sysmaster:'informix'.syscolauth
116057 8 sysmaster:'informix'.systables 116065 8
sysmaster:'informix'.sysviews 116073 8 sysmaster:'informix'.syscolumns
116081 8 sysmaster:'informix'.sysaudit 116089 8 sysutils:'informix'.
100_1 116097 4 FREE 116101 2 sysmaster:'informix'.sysindices 116103 8
sysmaster:'informix'.systabauth 116111 8 sysmaster:'informix'.sysviews
116119 8 sysmaster:'informix'.sysextspaces 116127 8
sysmaster:'informix'.sysprocbody 116135 8 sysutils:'informix'.systables
116143 8 sysutils:'informix'.syscolumns 116151 16
sysmaster:'informix'.syscolumns 116167 8 sysutils:'informix'.sysindices
116175 24 sysutils:'informix'.systabauth 116199 16
sysutils:'informix'.syscolauth 116215 8 sysutils:'informix'.sysviews
116223 8 sysutils:'informix'.sysusers 116231 8
sysutils:'informix'.sysdepend 116239 8 sysutils:'informix'.syssynonyms
116247 8 sysutils:'informix'.syssyntable 116255 8
sysutils:'informix'.sysconstraints 116263 8
sysutils:'informix'.sysreferences 116271 8 sysutils:'informix'.syschecks
116279 8 sysutils:'informix'.sysdefaults 116287 8
sysutils:'informix'.syscoldepend 116295 8
sysutils:'informix'.sysprocedures 116303 8
sysutils:'informix'.sysprocbody 116311 8 sysutils:'informix'.sysprocplan
116319 8 sysutils:'informix'.sysprocauth 116327 8
sysutils:'informix'.sysblobs 116335 8 sysutils:'informix'. 101_4 116343
4 sysmaster:'informix'.syscolumns 116347 8
sysutils:'informix'.sysopclstr 116355 8 sysutils:'informix'.systriggers
116363 8 sysutils:'informix'.systrigbody 116371 8
sysutils:'informix'.sysdistrib 116379 8 sysutils:'informix'.sysfragments
116387 8 sysutils:'informix'.sysfragauth 116395 8
sysutils:'informix'.sysxtdtypes 116403 8 sysutils:'informix'.sysxtddesc
116411 8 sysutils:'informix'.sysattrtypes 116419 8
sysutils:'informix'.sysinherits 116427 8
sysutils:'informix'.syscolattribs 116435 8 sysutils:'informix'.syslogmap
116443 8 sysutils:'informix'.syscasts 116451 24 FREE 116475 1
sysmaster:'informix'.sysfragments 116476 8
sysutils:'informix'.sysxtdtypeauth 116484 8 sysutils:'informix'.sysams
116492 8 sysutils:'informix'.systabamdata 116500 8
sysutils:'informix'.sysopclasses 116508 8
sysutils:'informix'.bar_obj_idx 116516 7 sysmaster:'informix'.sysindices
116523 8 sysutils:'informix'.syserrors 116531 8
sysutils:'informix'.systraceclasses 116539 8
sysutils:'informix'.systracemsgs 116547 8
sysutils:'informix'.sysroutinelangs 116555 8
sysutils:'informix'.syslangauth 116563 8
sysutils:'informix'.sysaggregates 116571 8
sysutils:'informix'.sysroleauth 116579 8 sysutils:'informix'.sysobjstate
116587 8 sysutils:'informix'.sysviolations 116595 8
sysutils:'informix'.systables 116603 8 sysutils:'informix'.sysprocbody
116611 16 sysutils:'informix'.sysprocedures 116627 8
sysutils:'informix'.sysprocbody 116635 8 sysutils:'informix'.sysprocauth
116643 8 sysutils:'informix'.sysprocbody 116651 16
sysutils:'informix'.sysprocedures 116667 8 FREE 116675 1
sysmaster:'informix'.syscolumns 116676 8 sysutils:'informix'.sysprocbody
116684 32 sysutils:'informix'.sysprocedures 116716 8
sysutils:'informix'.sysprocbody 116724 24
sysutils:'informix'.sysprocauth 116748 8
sysutils:'informix'.sysprocedures 116756 8
sysutils:'informix'.sysprocbody 116764 24
sysutils:'informix'.sysprocedures 116788 8
sysutils:'informix'.sysprocbody 116796 32
sysutils:'informix'.sysprocedures 116828 8
sysutils:'informix'.sysprocauth 116836 8 sysutils:'informix'.sysprocbody
116844 16 sysutils:'informix'.sysprocplan 116860 8
sysutils:'informix'.bar_server 116868 8 sysutils:'informix'.bar_object
116876 8 sysutils:'informix'.bar_action 116884 8 sysutils:'informix'.
102_9 116892 4 sysutils:'informix'. 102_10 116896 4
sysutils:'informix'.bar_instance 116900 8 sysutils:'informix'. 103_14
116908 4 sysutils:'informix'.syscolumns 116912 8 LOGICAL LOG: Log file
23 116920 50000 LOGICAL LOG: Log file 24 166920 50000 LOGICAL LOG: Log
file 25 216920 50000 LOGICAL LOG: Log file 26 266920 50000 LOGICAL LOG:
Log file 27 316920 50000 LOGICAL LOG: Log file 28 366920 50000 LOGICAL
LOG: Log file 29 416920 50000 LOGICAL LOG: Log file 30 466920 50000
LOGICAL LOG: Log file 31 516920 50000 LOGICAL LOG: Log file 32 566920
50000 LOGICAL LOG: Log file 33 616920 50000 LOGICAL LOG: Log file 34
666920 50000 LOGICAL LOG: Log file 35 716920 50000 LOGICAL LOG: Log file
36 766920 50000 LOGICAL LOG: Log file 37 816920 50000 FREE 866920 178080
Total Used: 852975
Total Free: 192025
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
