We want to load all the data of live server to the backup server afresh but we are not able to delete all the tables in the database. This is because one of the chunks has some problem.

We are not able to drop the chunk as it has some data in it. Is it possible to remove the chunk even if it is not empty ??



the output of various informix commands is as follows :


output of oncheck -pe
---------------------
DBspace Usage Report: rootdbs Owner: informix Created: 12/11/2003


Chunk Pathname Size Used Free
8 I:\informix\dbspaces\baandb_01 500000 71587 428413

Description Offset Size
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
FREE 3 1200
baandb:'informix'.sysobjstate 1203 2048

.
.
.
.
.
.
.
baandb_dbs:'informix'.TBLSpace 82387 400
baandb:'informix'.sysobjstate 82787 4096
FREE 86883 4756
baandb:'informix'.sysobjstate 91639 128
FREE 91767 100
baandb:'informix'.sysconstraints 91867 128
FREE 91995 48
baandb:'informix'.sysfragments 92043 32
FREE 92075 25588
baandb:'informix'.systabauth 117663 128
FREE 117791 692
baandb:'informix'.syscoldepend 118483 1024
FREE 119507 7892
ERROR: Extents overlap.
baandb:'baandb'.ttdind202920 125071 4
ERROR: Missing pages between 125075 and 125139
baandb:'baandb'.ttdind202920 125139 4
baandb:'baandb'.ttdind202920 125143 4
ERROR: Missing pages between 125147 and 127195
baandb:'baandb'.ttdind202920 127195 204
baandb:'informix'.systabauth 127399 128
FREE 127527 2096
ERROR: Extents overlap.
baandb:'baandb'.ttdind202920 129575 48
baandb:'informix'.syscoldepend 129623 32
baandb:'informix'.sysconstraints 129655 4096
FREE 133751 36268
ERROR: Extents overlap.
baandb:'baandb'.ttdind202920 133751 224
ERROR: Missing pages between 133975 and 136023
baandb:'baandb'.ttdind202920 136023 164
ERROR: Missing pages between 136187 and 138235
baandb:'baandb'.ttdind202920 138235 260
ERROR: Missing pages between 138495 and 140543
baandb:'baandb'.ttdind202920 140543 324
ERROR: Missing pages between 140867 and 144963
baandb:'baandb'.ttdind202920 144963 104
ERROR: Missing pages between 145067 and 147115
baandb:'baandb'.ttdind202920 147115 304
baandb:'baandb'.ttdind222920 147419 4
baandb:'baandb'.ttdind204920 147423 4
baandb:'baandb'.ttdind205920 147427 4
baandb:'baandb'.ttdind220920 147431 4
baandb:'baandb'.ttdind221920 147435 4
baandb:'baandb'.ttdind222920 147439 4
baandb:'baandb'.ttdind222920 147443 128
ERROR: Missing pages between 147571 and 149619
baandb:'baandb'.ttdind222920 149619 172
ERROR: Missing pages between 149791 and 170019
baandb:'informix'.syscoldepend 170019 512
FREE 170531 12860
baandb:'informix'.sysconstraints 183391 4096
FREE 187487 732
baandb:'informix'.systabauth



output of oncheck -ce
----------------------

Validating extents for Space 'baandb_dbs' ...

Chunk Pathname Size Used Free
4 I:\informix\dbspaces\baandb 512000 379779 132221
8 I:\informix\dbspaces\baandb_01 500000 71587 428413

ERROR:
Extent Description Start Length
------------------ ----- ------
FREE 119507 7892
overlaps ...
baandb:'baandb'.ttdind202920 125071 4
ERROR: Missing pages between 125075 and 125139
ERROR: Missing pages between 125147 and 127195

ERROR:
Extent Description Start Length
------------------ ----- ------
FREE 127527 2096
overlaps ...
baandb:'baandb'.ttdind202920 129575 48

ERROR:
Extent Description Start Length
------------------ ----- ------
FREE 133751 36268
overlaps ...
baandb:'baandb'.ttdind202920 133751 224
ERROR: Missing pages between 133975 and 136023
ERROR: Missing pages between 136187 and 138235
ERROR: Missing pages between 138495 and 140543
ERROR: Missing pages between 140867 and 144963
ERROR: Missing pages between 145067 and 147115
ERROR: Missing pages between 147571 and 149619
ERROR: Missing pages between 149791 and 170019
9 I:\informix\dbspaces\baandb_02 500000 34643 465357
10 I:\informix\dbspaces\baandb_03 500000 13987 486013
11 I:\informix\dbspaces\baandb_04 500000 17507 482493
12 J:\informix\dbspaces\baandb_05 500000 15899 484101
13 J:\informix\dbspaces\baandb_06 500000 1739 498261
17 k:\informix\dbspaces\baandb_10 500000 339 499661
20 I:\informix\dbspaces\baandb_13 500000 871 499129
21 I:\informix\dbspaces\baandb_14 500000 14987 485013


Validating extents for Space 'baandb_plog' ...

Chunk Pathname Size Used Free
5 G:\informix\Dbspaces\baandbplog 52480 51253 1227


Validating extents for Space 'baandb_llog' ...

Chunk Pathname Size Used Free
6 H:\informix\Dbspaces\baandbllog 131200 128053 3147


Validating extents for Space 'baandb_tmp' ...

Chunk Pathname Size Used Free
7 H:\informix\Dbspaces\baandbtmp 128000 53 127947


Validating extents for Space 'baandb_i_dbs' ...

Chunk Pathname Size Used Free
22 i:\Informix\dbspaces\baandb_I_dbs_04 500000 3 499997
24 k:\Informix\dbspaces\baandb_I_dbs 500000 5003 494997

ERROR:
Extent Description Start Length
------------------ ----- ------
FREE 25275 87456
overlaps ...
baandb:'baandb'.tdind2029202abaand 39351 4
ERROR: Missing pages between 39355 and 39535
ERROR: Missing pages between 39599 and 39855
ERROR: Missing pages between 40119 and 40247
ERROR: Missing pages between 40751 and 41007
ERROR: Missing pages between 41055 and 41183
ERROR: Missing pages between 41787 and 41915
ERROR: Missing pages between 42043 and 42299
ERROR: Missing pages between 42419 and 112731
25 K:\Informix\dbspaces\baandb_I_dbs_01 500000 3 499997
26 K:\Informix\dbspaces\baandb_I_dbs_02 500000 3 499997
27 K:\Informix\dbspaces\baandb_I_dbs_03 500000 3 499997


Validating extents for Space 'bdb_c920_tfgld106' ...

Chunk Pathname Size Used Free
14 K:\Informix\dbspaces\bdb_c920_tfgld106 500000 53 499947
15 K:\Informix\dbspaces\bdb_c920_tfgld106_01 500000 3 499997
16 K:\Informix\dbspaces\bdb_c920_tfgld106_02 500000 3 499997
32 j:\Informix\dbspaces\bdb_c920_tfgld106_03 500000 3 499997


Validating extents for Space 'bdb_c920_i_tfgld106' ...

Chunk Pathname Size Used Free
18 J:\Informix\dbspaces\bdb_c920_I_tfgld106 500000 53 499947
19 J:\Informix\dbspaces\bdb_c920_I_tfgld106_01 500000 3 499997
ERROR: Missing pages between 407555 and 499715
23 I:\informix\dbspaces\bdb_c920_I_tfgld106_04 500000 3 499997
28 J:\Informix\dbspaces\bdb_c920_I_tfgld106_02 500000 3 499997
ERROR: Missing pages between 3 and 18435
35 k:\Informix\dbspaces\bdb_c920_I_tfgld106_03 500000 3 499997


Validating extents for Space 'bdb_c920_tfgld418' ...

Chunk Pathname Size Used Free
29 J:\Informix\dbspaces\bdb_c920_tfgld418 500000 53 499947
30 J:\Informix\dbspaces\bdb_c920_tfgld418_01 500000 3 499997
31 J:\Informix\dbspaces\bdb_c920_tfgld418_02 500000 3 499997


Validating extents for Space 'bdb_c920_i_tfgld418' ...

Chunk Pathname Size Used Free
33 k:\Informix\dbspaces\bdb_c920_I_tfgld418 500000 53 499947
ERROR: Missing pages between 41057 and 52833
34 k:\Informix\dbspaces\bdb_c920_I_tfgld418_01 500000 3 499997
36 k:\Informix\dbspaces\bdb_c920_I_tfgld418_02 250000 3 249997
37 k:\Informix\dbspaces\bdb_c920_I_tfgld418_03 125000 3 124997[/FONT][/SIZE]

If it is not possible to drop the chunk (with data) which seems the case, I thought of another option.

I have sequential dump of tools company. May be I can drop the dbspace and recreate it. But how do i again (create tables and) updload the sequential data of tools company in Informix without logged into Baan??

Is this possible ??

Hi there,

sure enough it is ....
bdbpost6.1 loads seq. dump of table(s) back into the DB.
For usage call bdbpost6.1 -U
This is exactly the same program which is started when you use the session 'Create Table from seq. Dump' in Baan.

hth

Norbert