Database Repair: attempt to update non-existant extent. Area: 7 Extent: 1

[Joe20171]

To List:


progress/OpenEdge release 10.1B03

I am cloning a progress database from source file systems to destination file systems.
(same server)

Steps:

1. STOP destination DB in /progdba1db01 ( to get a clean backup)

2. Backup all unifipc* in destination folder /progdba1db01

3. stop source DB in /progdev1db01

2. cp all AI, BI and DB files from source folder /progdev1db01
to destination folder /progdba1db01

files copied:
/progdev1db01/unifipc*
/progdev1db02/unifipc*
/progdev1db03/unifipc*
/progdev1ai/unifipc*
/progdev1bi/unifipc*
/progdev1indx/unifipc*

including unifipc.st

3. In destination folder /progdba1db01
mass change unifipc.st from /progdev1 to /progdba1

4. issue prostrct repair unifipc unifipc.st
failed with Database Repair: attempt to update non-existant extent. Area: 7 Extent: 1
(looked around, unifipc_7.d1 is not defined in unifipc.st)


Question: Like to know why does prostrct repair kept looking for unifipc_7.d1 when it is not even defined in unifipc.st.

Thanks !

Joe

 

[LarryD]

Here is what I would suggest:

1. STOP destination DB in /progdba1db01 ( to get a clean backup)

2. truncate the bi (not sure if this step is necessary, but I like to do it)

3. Use probkup to backup the db in /progdba1db01 to some backup file

4. stop source DB in /progdev1db01

5. use prodel to delete the db in /progdev1db01

6. make sure the .st file for the new db resides in /progdev1db01

7. use prorest to restore the original db to /progdev1db01 from the probkup file. The .st file residing in the /progdev1db01 will be used to create the extents.

8. Done.

Pretty sure I haven't missed anything, and perhaps others have better solutions (I know at least 1 person on this forum always has a different solution ;-) )

 

[Joe20171]

We plan to copy all files (*.ai, *.bi and *.d* *.st ) from production server to our disaster recovery site using Flash Copy, we use << proquiet >> to acquire a quiese point before issuing Flash Copy commands. (that's why probkup or prorest is not an option for us, we are talking about hours vs minutes).

I use cp to mimic Flash copy for testing purpose due to Flash copy is not yet deployed.

Joe

 

[LarryD]

What does prostrct list on the DB in /progdba1db01 show?

 

[Joe20171]

I manually changed unifipc.st from from /progdev1 to /progdba1 after cp from /progdev1db01 to /progdba1db01

After prostrct list db-name, I saw /progdba1 was changed back to /progdev1 in unifipc.st


Joe

 

[TomBascom]

DB Repair and Prostrct Repair are very different utilities.

So either that isn't really the command that you typed or that isn't the message you received. Or your system is seriously corrupted.

Assuming that you really used prostrct repair and that the message is from prostrct repair rather than db repair then the most likely explanation is that the .st file you are looking at is not the one which prostrct repair is trying to use.

So I suggest posting the actual commands, the actual output, the actual content of the .st file and an "ls -l" of the directory in question. (It will be a lot more readable if you post it as "code".)

 

[cj_brandt]

run a string unifipc.db and see if that extent - unifipc_7.d1 - appears.

Making OS copies of databases can be a bit tricky because you can miss an extent...

 

[Joe20171]

------------------------------------------------------------

===> command issued: /progdba1db01 $ prostrct repair unifipc unifipc.st
Database Repair: attempt to update non-existant extent.
Area: 7 Extent: 1
Prostrct repair of database unifipc using structure file unifipc.st completed. (13485)

-------------------------------------------------------------


/progdba1ai $ ls unifipc*
unifipc.a1 unifipc.a2 unifipc.a3 unifipc.a4 unifipc.a5
/progdba1bi $ ls unifipc*
unifipc.b1 unifipc.b2 unifipc.b3 unifipc.b4 unifipc.b5
/progdba1db01 $ ls unifipc*
unifipc.d060419.df unifipc2.pf unifipc_60.d2
unifipc.db unifipc52DEV1.st unifipc_60.d3
unifipc.df unifipcV10DEV1.df unifipc_71.d7
unifipc.df.d070808 unifipcV10original.df unifipc_73.d4
unifipc.lg unifipc_51.d3 unifipc_77.d3
unifipc.lg.old unifipc_52.d3 unifipc_77.d4
unifipc.lic unifipc_52.d4 unifipc_79.d3
unifipc.st unifipc_55.d4 unifipc_79.d4
unifipc.st.d090507 unifipc_58.d3 unifipc_92.d1
unifipc.st.d091009 unifipc_59.d3 unifipc_92.d2
unifipc.st.d100827 unifipc_59.d4 unifipc_92.d3
unifipc1.pf unifipc_60.d1 unifipc_92.d7


/progdba1db02 $ ls unifipc*
unifipc.d1 unifipc_56.d1 unifipc_71.d3 unifipc_81.d4 unifipc_87.d4
unifipc_51.d2 unifipc_56.d3 unifipc_71.d8 unifipc_83.d1 unifipc_89.d1
unifipc_51.d4 unifipc_56.d4 unifipc_73.d2 unifipc_85.d2 unifipc_90.d2
unifipc_52.d1 unifipc_56.d5 unifipc_75.d1 unifipc_85.d3 unifipc_92.d4
unifipc_53.d2 unifipc_58.d1 unifipc_77.d2 unifipc_85.d4 unifipc_92.d6
unifipc_54.d1 unifipc_58.d4 unifipc_79.d1 unifipc_87.d1 unifipc_92.d8
unifipc_54.d3 unifipc_59.d2 unifipc_81.d2 unifipc_87.d2 unifipc_93.d2
unifipc_55.d2 unifipc_71.d1 unifipc_81.d3 unifipc_87.d3
/progdba1db03 $ ls unifipc*
unifipc.d2 unifipc_55.d1 unifipc_71.d5 unifipc_81.d1 unifipc_88.d4
unifipc_51.d1 unifipc_55.d3 unifipc_71.d6 unifipc_83.d2 unifipc_89.d2
unifipc_52.d2 unifipc_56.d2 unifipc_71.d9 unifipc_83.d3 unifipc_89.d3
unifipc_53.d1 unifipc_56.d6 unifipc_73.d1 unifipc_83.d4 unifipc_89.d4
unifipc_53.d3 unifipc_58.d2 unifipc_73.d3 unifipc_85.d1 unifipc_90.d1
unifipc_53.d4 unifipc_59.d1 unifipc_75.d2 unifipc_88.d1 unifipc_92.d5
unifipc_54.d2 unifipc_71.d2 unifipc_77.d1 unifipc_88.d2 unifipc_92.d9
unifipc_54.d4 unifipc_71.d4 unifipc_79.d2 unifipc_88.d3 unifipc_93.d1

/progdba1indx $ ls unifipc*
unifipc_61.d1 unifipc_64.d2 unifipc_68.d2 unifipc_74.d1 unifipc_82.d2
unifipc_61.d2 unifipc_64.d3 unifipc_68.d3 unifipc_74.d2 unifipc_82.d3
unifipc_61.d3 unifipc_64.d4 unifipc_68.d4 unifipc_74.d3 unifipc_82.d4
unifipc_61.d4 unifipc_65.d1 unifipc_69.d1 unifipc_74.d4 unifipc_84.d1
unifipc_62.d1 unifipc_65.d2 unifipc_69.d2 unifipc_76.d1 unifipc_84.d2
unifipc_62.d2 unifipc_65.d3 unifipc_70.d1 unifipc_76.d2 unifipc_84.d3
unifipc_62.d3 unifipc_65.d4 unifipc_70.d2 unifipc_78.d1 unifipc_84.d4
unifipc_62.d4 unifipc_66.d1 unifipc_70.d3 unifipc_78.d2 unifipc_86.d1
unifipc_62.d5 unifipc_66.d2 unifipc_70.d4 unifipc_78.d3 unifipc_86.d2
unifipc_62.d6 unifipc_66.d3 unifipc_72.d1 unifipc_78.d4 unifipc_86.d3
unifipc_63.d1 unifipc_66.d4 unifipc_72.d2 unifipc_80.d1 unifipc_86.d4
unifipc_63.d2 unifipc_66.d5 unifipc_72.d3 unifipc_80.d2 unifipc_91.d1
unifipc_63.d3 unifipc_67.d1 unifipc_72.d4 unifipc_80.d3 unifipc_91.d2
unifipc_63.d4 unifipc_67.d2 unifipc_72.d5 unifipc_80.d4 unifipc_94.d1
unifipc_64.d1 unifipc_68.d1 unifipc_72.d6 unifipc_82.d1 unifipc_94.d2



--------------------------------------------------------------
==============> unifipc.st
　
b /progdba1bi/unifipc.b1 f 256000
b /progdba1bi/unifipc.b2 f 256000
b /progdba1bi/unifipc.b3 f 256000
b /progdba1bi/unifipc.b4 f 256000
b /progdba1bi/unifipc.b5
#
d "Schema Area":6,64;1 /progdba1db02/unifipc.d1 f 128000
d "Schema Area":6,64;1 /progdba1db03/unifipc.d2
#
a /progdba1ai/unifipc.a1 f 256000
#
a /progdba1ai/unifipc.a2 f 256000
#
a /progdba1ai/unifipc.a3 f 256000
#
a /progdba1ai/unifipc.a4 f 256000
#
a /progdba1ai/unifipc.a5
#
d "lt-payout-na Type 2":51,64;64 /progdba1db03/unifipc_51.d1 f 22528
d "lt-payout-na Type 2":51,64;64 /progdba1db02/unifipc_51.d2 f 512
d "lt-payout-na Type 2":51,64;64 /progdba1db01/unifipc_51.d3 f 22528
d "lt-payout-na Type 2":51,64;64 /progdba1db02/unifipc_51.d4
#
d "uca-field-audit Type 2":52,64;64 /progdba1db02/unifipc_52.d1 f 12928
d "uca-field-audit Type 2":52,64;64 /progdba1db03/unifipc_52.d2 f 512
d "uca-field-audit Type 2":52,64;64 /progdba1db01/unifipc_52.d3 f 30720
d "uca-field-audit Type 2":52,64;64 /progdba1db01/unifipc_52.d4
#
d "lt-comment Type 2":53,64;64 /progdba1db03/unifipc_53.d1 f 12928
d "lt-comment Type 2":53,64;64 /progdba1db02/unifipc_53.d2 f 512
d "lt-comment Type 2":53,64;64 /progdba1db03/unifipc_53.d3 f 14336
d "lt-comment Type 2":53,64;64 /progdba1db03/unifipc_53.d4
#
d "lt-condition Type 2":54,64;64 /progdba1db02/unifipc_54.d1 f 18304
d "lt-condition Type 2":54,64;64 /progdba1db03/unifipc_54.d2 f 512
d "lt-condition Type 2":54,64;64 /progdba1db02/unifipc_54.d3 f 102400
d "lt-condition Type 2":54,64;64 /progdba1db03/unifipc_54.d4
#
d "lt-payout Type 2":55,64;64 /progdba1db03/unifipc_55.d1 f 32768
d "lt-payout Type 2":55,64;64 /progdba1db02/unifipc_55.d2 f 512
d "lt-payout Type 2":55,64;64 /progdba1db03/unifipc_55.d3 f 32768
d "lt-payout Type 2":55,64;64 /progdba1db01/unifipc_55.d4
#
#
d "lt-queue Type 2":56,64;64 /progdba1db02/unifipc_56.d1 f 16896
d "lt-queue Type 2":56,64;64 /progdba1db03/unifipc_56.d2 f 512
d "lt-queue Type 2":56,64;64 /progdba1db02/unifipc_56.d3 f 18432
d "lt-queue Type 2":56,64;64 /progdba1db02/unifipc_56.d4 f 4096
d "lt-queue Type 2":56,64;64 /progdba1db02/unifipc_56.d5 f 102400
d "lt-queue Type 2":56,64;64 /progdba1db03/unifipc_56.d6
#
d "ucb-trade Type 2":58,64;64 /progdba1db02/unifipc_58.d1 f 48000
d "ucb-trade Type 2":58,64;64 /progdba1db03/unifipc_58.d2 f 512
d "ucb-trade Type 2":58,64;64 /progdba1db01/unifipc_58.d3 f 102400
d "ucb-trade Type 2":58,64;64 /progdba1db02/unifipc_58.d4
#
d "lt-prospect-msg Type 2":59,64;64 /progdba1db03/unifipc_59.d1 f 94848
d "lt-prospect-msg Type 2":59,64;64 /progdba1db02/unifipc_59.d2 f 512
d "lt-prospect-msg Type 2":59,64;64 /progdba1db01/unifipc_59.d3 f 102400
d "lt-prospect-msg Type 2":59,64;64 /progdba1db01/unifipc_59.d4
#
d "ucb-b-image Type 2":60,64;64 /progdba1db01/unifipc_60.d1 f 512000
d "ucb-b-image Type 2":60,64;64 /progdba1db01/unifipc_60.d2 f 512000
d "ucb-b-image Type 2":60,64;64 /progdba1db01/unifipc_60.d3
#
d "lt-payout-na-INDEX Type 2":61,64;64 /progdba1indx/unifipc_61.d1 f 2048
d "lt-payout-na-INDEX Type 2":61,64;64 /progdba1indx/unifipc_61.d2 f 1024
d "lt-payout-na-INDEX Type 2":61,64;64 /progdba1indx/unifipc_61.d3 f 6144
d "lt-payout-na-INDEX Type 2":61,64;64 /progdba1indx/unifipc_61.d4
#
d "uca-field-audit-INDEX Type 2":62,64;64 /progdba1indx/unifipc_62.d1 f 3584
d "uca-field-audit-INDEX Type 2":62,64;64 /progdba1indx/unifipc_62.d2 f 1024
d "uca-field-audit-INDEX Type 2":62,64;64 /progdba1indx/unifipc_62.d3 f 6144
d "uca-field-audit-INDEX Type 2":62,64;64 /progdba1indx/unifipc_62.d4 f 512
d "uca-field-audit-INDEX Type 2":62,64;64 /progdba1indx/unifipc_62.d5 f 22528
d "uca-field-audit-INDEX Type 2":62,64;64 /progdba1indx/unifipc_62.d6
#
d "lt-comment-INDEX Type 2":63,64;64 /progdba1indx/unifipc_63.d1 f 640
d "lt-comment-INDEX Type 2":63,64;64 /progdba1indx/unifipc_63.d2 f 1024
d "lt-comment-INDEX Type 2":63,64;64 /progdba1indx/unifipc_63.d3 f 6144
d "lt-comment-INDEX Type 2":63,64;64 /progdba1indx/unifipc_63.d4
#
d "lt-condition-INDEX Type 2":64,64;64 /progdba1indx/unifipc_64.d1 f 1024
d "lt-condition-INDEX Type 2":64,64;64 /progdba1indx/unifipc_64.d2 f 1536
d "lt-condition-INDEX Type 2":64,64;64 /progdba1indx/unifipc_64.d3 f 6144
d "lt-condition-INDEX Type 2":64,64;64 /progdba1indx/unifipc_64.d4
#
d "lt-payout-INDEX Type 2":65,64;64 /progdba1indx/unifipc_65.d1 f 3968
d "lt-payout-INDEX Type 2":65,64;64 /progdba1indx/unifipc_65.d2 f 1024
d "lt-payout-INDEX Type 2":65,64;64 /progdba1indx/unifipc_65.d3 f 6144
d "lt-payout-INDEX Type 2":65,64;64 /progdba1indx/unifipc_65.d4
#
d "lt-queue-INDEX Type 2":66,64;64 /progdba1indx/unifipc_66.d1 f 3584
d "lt-queue-INDEX Type 2":66,64;64 /progdba1indx/unifipc_66.d2 f 4608
d "lt-queue-INDEX Type 2":66,64;64 /progdba1indx/unifipc_66.d3 f 6144
d "lt-queue-INDEX Type 2":66,64;64 /progdba1indx/unifipc_66.d4 f 6144
d "lt-queue-INDEX Type 2":66,64;64 /progdba1indx/unifipc_66.d5
#
d "lt-bin-dtl-INDEX Type 2":67,64;64 /progdba1indx/unifipc_67.d1 f 512
d "lt-bin-dtl-INDEX Type 2":67,64;64 /progdba1indx/unifipc_67.d2
#
d "ucb-trade-INDEX Type 2":68,64;64 /progdba1indx/unifipc_68.d1 f 4992
d "ucb-trade-INDEX Type 2":68,64;64 /progdba1indx/unifipc_68.d2 f 512
d "ucb-trade-INDEX Type 2":68,64;64 /progdba1indx/unifipc_68.d3 f 7168
d "ucb-trade-INDEX Type 2":68,64;64 /progdba1indx/unifipc_68.d4
#
d "lt-prospect-msg-INDEX Type 2":69,64;64 /progdba1indx/unifipc_69.d1 f 512
d "lt-prospect-msg-INDEX Type 2":69,64;64 /progdba1indx/unifipc_69.d2
#
d "ucb-b-image-INDEX Type 2":70,64;64 /progdba1indx/unifipc_70.d1 f 1024
d "ucb-b-image-INDEX Type 2":70,64;64 /progdba1indx/unifipc_70.d2 f 1024
d "ucb-b-image-INDEX Type 2":70,64;64 /progdba1indx/unifipc_70.d3 f 5120
d "ucb-b-image-INDEX Type 2":70,64;64 /progdba1indx/unifipc_70.d4
#
d "Table Area Group 1 Type 2":71,64;64 /progdba1db02/unifipc_71.d1 f 25600
d "Table Area Group 1 Type 2":71,64;64 /progdba1db03/unifipc_71.d2 f 25600
d "Table Area Group 1 Type 2":71,64;64 /progdba1db02/unifipc_71.d3 f 25600
d "Table Area Group 1 Type 2":71,64;64 /progdba1db03/unifipc_71.d4 f 224768
d "Table Area Group 1 Type 2":71,64;64 /progdba1db03/unifipc_71.d5 f 529408
d "Table Area Group 1 Type 2":71,64;64 /progdba1db03/unifipc_71.d6 f 512
d "Table Area Group 1 Type 2":71,64;64 /progdba1db01/unifipc_71.d7 f 25600
d "Table Area Group 1 Type 2":71,64;64 /progdba1db02/unifipc_71.d8 f 25600
d "Table Area Group 1 Type 2":71,64;64 /progdba1db03/unifipc_71.d9
#
d "Index Area Group 1 Type 2":72,64;64 /progdba1indx/unifipc_72.d1 f 128000
d "Index Area Group 1 Type 2":72,64;64 /progdba1indx/unifipc_72.d2 f 128000
d "Index Area Group 1 Type 2":72,64;64 /progdba1indx/unifipc_72.d3 f 128000
d "Index Area Group 1 Type 2":72,64;64 /progdba1indx/unifipc_72.d4 f 512
d "Index Area Group 1 Type 2":72,64;64 /progdba1indx/unifipc_72.d5 f 537600
d "Index Area Group 1 Type 2":72,64;64 /progdba1indx/unifipc_72.d6
#
d "lt-master Type 2":73,64;64 /progdba1db03/unifipc_73.d1 f 6144
d "lt-master Type 2":73,64;64 /progdba1db02/unifipc_73.d2 f 2560
d "lt-master Type 2":73,64;64 /progdba1db03/unifipc_73.d3 f 22528
d "lt-master Type 2":73,64;64 /progdba1db01/unifipc_73.d4
#
d "lt-master-INDEX Type 2":74,64;64 /progdba1indx/unifipc_74.d1 f 768
d "lt-master-INDEX Type 2":74,64;64 /progdba1indx/unifipc_74.d2 f 4096
d "lt-master-INDEX Type 2":74,64;64 /progdba1indx/unifipc_74.d3 f 5120
d "lt-master-INDEX Type 2":74,64;64 /progdba1indx/unifipc_74.d4
#
d "cb-image Type 2":75,64;64 /progdba1db02/unifipc_75.d1 f 2304
d "cb-image Type 2":75,64;64 /progdba1db03/unifipc_75.d2
#
d "cb-image-INDEX Type 2":76,64;64 /progdba1indx/unifipc_76.d1 f 512
d "cb-image-INDEX Type 2":76,64;64 /progdba1indx/unifipc_76.d2
#
d "lt-borrower Type 2":77,64;64 /progdba1db03/unifipc_77.d1 f 5632
d "lt-borrower Type 2":77,64;64 /progdba1db02/unifipc_77.d2 f 512
d "lt-borrower Type 2":77,64;64 /progdba1db01/unifipc_77.d3 f 8192
d "lt-borrower Type 2":77,64;64 /progdba1db01/unifipc_77.d4
#
d "lt-borrower-INDEX Type 2":78,64;64 /progdba1indx/unifipc_78.d1 f 768
d "lt-borrower-INDEX Type 2":78,64;64 /progdba1indx/unifipc_78.d2 f 1536
d "lt-borrower-INDEX Type 2":78,64;64 /progdba1indx/unifipc_78.d3 f 6144
d "lt-borrower-INDEX Type 2":78,64;64 /progdba1indx/unifipc_78.d4
#
d "lt-property Type 2":79,64;64 /progdba1db02/unifipc_79.d1 f 7040
d "lt-property Type 2":79,64;64 /progdba1db03/unifipc_79.d2 f 512
d "lt-property Type 2":79,64;64 /progdba1db01/unifipc_79.d3 f 9216
d "lt-property Type 2":79,64;64 /progdba1db01/unifipc_79.d4
#
d "lt-property-INDEX Type 2":80,64;64 /progdba1indx/unifipc_80.d1 f 512
d "lt-property-INDEX Type 2":80,64;64 /progdba1indx/unifipc_80.d2 f 1536
d "lt-property-INDEX Type 2":80,64;64 /progdba1indx/unifipc_80.d3 f 5120
d "lt-property-INDEX Type 2":80,64;64 /progdba1indx/unifipc_80.d4
#
d "ltp-common-n-a Type 2":81,64;64 /progdba1db03/unifipc_81.d1 f 512
d "ltp-common-n-a Type 2":81,64;64 /progdba1db02/unifipc_81.d2 f 4608
d "ltp-common-n-a Type 2":81,64;64 /progdba1db02/unifipc_81.d3 f 6144
d "ltp-common-n-a Type 2":81,64;64 /progdba1db02/unifipc_81.d4
#
d "ltp-common-n-a-INDEX Type 2":82,64;64 /progdba1indx/unifipc_82.d1 f 512
d "ltp-common-n-a-INDEX Type 2":82,64;64 /progdba1indx/unifipc_82.d2 f 2560
d "ltp-common-n-a-INDEX Type 2":82,64;64 /progdba1indx/unifipc_82.d3 f 6144
d "ltp-common-n-a-INDEX Type 2":82,64;64 /progdba1indx/unifipc_82.d4
#
d "ml-misc Type 2":83,64;64 /progdba1db02/unifipc_83.d1 f 44544
d "ml-misc Type 2":83,64;64 /progdba1db03/unifipc_83.d2 f 53248
d "ml-misc Type 2":83,64;64 /progdba1db03/unifipc_83.d3 f 108544
d "ml-misc Type 2":83,64;64 /progdba1db03/unifipc_83.d4
#
d "ml-misc-INDEX Type 2":84,64;64 /progdba1indx/unifipc_84.d1 f 1536
d "ml-misc-INDEX Type 2":84,64;64 /progdba1indx/unifipc_84.d2 f 2560
d "ml-misc-INDEX Type 2":84,64;64 /progdba1indx/unifipc_84.d3 f 6144
d "ml-misc-INDEX Type 2":84,64;64 /progdba1indx/unifipc_84.d4
#
d "ml-select Type 2":85,64;64 /progdba1db03/unifipc_85.d1 f 56320
d "ml-select Type 2":85,64;64 /progdba1db02/unifipc_85.d2 f 402432
d "ml-select Type 2":85,64;64 /progdba1db02/unifipc_85.d3 f 537600
d "ml-select Type 2":85,64;64 /progdba1db02/unifipc_85.d4
#
d "ml-select-INDEX Type 2":86,64;64 /progdba1indx/unifipc_86.d1 f 1536
d "ml-select-INDEX Type 2":86,64;64 /progdba1indx/unifipc_86.d2 f 2560
d "ml-select-INDEX Type 2":86,64;64 /progdba1indx/unifipc_86.d3 f 6144
d "ml-select-INDEX Type 2":86,64;64 /progdba1indx/unifipc_86.d4
#
d "Table Area Group 0 Type 2":87,64;64 /progdba1db02/unifipc_87.d1 f 512
d "Table Area Group 0 Type 2":87,64;64 /progdba1db02/unifipc_87.d2 f 48128
d "Table Area Group 0 Type 2":87,64;64 /progdba1db02/unifipc_87.d3 f 54272
d "Table Area Group 0 Type 2":87,64;64 /progdba1db02/unifipc_87.d4
#
d "Table Area Group 2 Type 2":88,64;64 /progdba1db03/unifipc_88.d1 f 128000
d "Table Area Group 2 Type 2":88,64;64 /progdba1db03/unifipc_88.d2 f 50688
d "Table Area Group 2 Type 2":88,64;64 /progdba1db03/unifipc_88.d3 f 322560
d "Table Area Group 2 Type 2":88,64;64 /progdba1db03/unifipc_88.d4
#
d "Table Area Group 3 Type 2":89,64;64 /progdba1db02/unifipc_89.d1 f 1024
d "Table Area Group 3 Type 2":89,64;64 /progdba1db03/unifipc_89.d2 f 52736
d "Table Area Group 3 Type 2":89,64;64 /progdba1db03/unifipc_89.d3 f 108544
d "Table Area Group 3 Type 2":89,64;64 /progdba1db03/unifipc_89.d4
#
d "lt-borr-score Type 2":90,64;64 /progdba1db03/unifipc_90.d1 f 12800
d "lt-borr-score Type 2":90,64;64 /progdba1db02/unifipc_90.d2
#
d "lt-borr-score-INDEX Type 2":91,64;64 /progdba1indx/unifipc_91.d1 f 6400
d "lt-borr-score-INDEX Type 2":91,64;64 /progdba1indx/unifipc_91.d2
#
d "lt-bin-dtl Type 2a":92,4;512 /progdba1db01/unifipc_92.d1 f 64000
d "lt-bin-dtl Type 2a":92,4;512 /progdba1db01/unifipc_92.d2 f 128000
d "lt-bin-dtl Type 2a":92,4;512 /progdba1db01/unifipc_92.d3 f 256000
d "lt-bin-dtl Type 2a":92,4;512 /progdba1db02/unifipc_92.d4 f 256000
d "lt-bin-dtl Type 2a":92,4;512 /progdba1db03/unifipc_92.d5 f 128000
d "lt-bin-dtl Type 2a":92,4;512 /progdba1db02/unifipc_92.d6 f 4096
d "lt-bin-dtl Type 2a":92,4;512 /progdba1db01/unifipc_92.d7 f 256000
d "lt-bin-dtl Type 2a":92,4;512 /progdba1db02/unifipc_92.d8 f 256000
d "lt-bin-dtl Type 2a":92,4;512 /progdba1db03/unifipc_92.d9
#
d "lt-gfe-hist-pay Type 2":93,64;64 /progdba1db03/unifipc_93.d1 f 32768
d "lt-gfe-hist-pay Type 2":93,64;64 /progdba1db02/unifipc_93.d2
#
d "lt-gfe-hist-pay-INDEX Type 2":94,64;64 /progdba1indx/unifipc_94.d1 f 3968
d "lt-gfe-hist-pay-INDEX Type 2":94,64;64 /progdba1indx/unifipc_94.d2

--------------------------------------------------------------------------

 

[Joe20171]

Hi Tom:

Exact command, error message, ST file and ls output attached

Thanks
Joe

 

[TomBascom]

CJ's idea is a good one.

Also -- is the any chance that in your editing you might have inserted a ^H right after a "7"? Like in _7^H0.d1

 

[Joe20171]

CJ: what utility does the stringing ? Progress utility ?
Thanks !

 

[TomBascom]

The command is named "strings".

 

[Joe20171]

Excellent site, excellent people !

This site made a mainframe guy like myself feel at home !

I tried strings command and as I expected, unifipc_7.d1 not found.

Joe

 

[Joe20171]

/progdba1db01 $ strings -a unifipc.db | grep unifipc_7
/progdev1db03/unifipc_71.d9ú
/progdev1db02/unifipc_71.d8ú
/progdev1db01/unifipc_71.d7ú
/progdev1indx/unifipc_70.d4ú
/progdev1indx/unifipc_70.d3ú
/progdev1db01/unifipc_73.d4ú
/progdev1db03/unifipc_73.d3ú
/progdev1db01/unifipc_79.d4ú
/progdev1db01/unifipc_79.d3ú
/progdev1db01/unifipc_77.d4ú
/progdev1db01/unifipc_77.d3ú
/progdev1indx/unifipc_70.d2ú
/progdev1db02/unifipc_73.d2ú
/progdev1db03/unifipc_79.d2ú
/progdev1db02/unifipc_77.d2ú
/progdev1indx/unifipc_78.d2ú
/progdev1indx/unifipc_74.d2ú
/progdev1indx/unifipc_72.d4ú
/progdev1db03/unifipc_71.d4ú
/progdev1db02/unifipc_79.d1ú
/progdev1indx/unifipc_78.d1ú
/progdev1db03/unifipc_77.d1ú
/progdev1indx/unifipc_76.d2ú
/progdev1indx/unifipc_76.d1ú
/progdev1db03/unifipc_75.d2ú
/progdev1db02/unifipc_75.d1ú
/progdev1indx/unifipc_74.d1ú
/progdev1db03/unifipc_73.d1ú
/progdev1indx/unifipc_72.d3ú
/progdev1indx/unifipc_72.d2ú
/progdev1indx/unifipc_72.d1ú
/progdev1db02/unifipc_71.d3ú
/progdev1db03/unifipc_71.d2ú
/progdev1db02/unifipc_71.d1ú
/progdev1indx/unifipc_70.d1ú
/progdev1db03/unifipc_71.d6ú
/progdev1indx/unifipc_78.d4ú
/progdev1indx/unifipc_78.d3ú
/progdev1indx/unifipc_74.d4ú
/progdev1indx/unifipc_74.d3ú
/progdev1indx/unifipc_72.d6ú
/progdev1indx/unifipc_72.d5ú
/progdev1db03/unifipc_71.d5ú

 

[Rob Fitzpatrick]

As Larry indicated, you should run prostrct list to ensure that the structure file you are working with is up to date. Syntax: prostrct list <dbname>.

This will overwrite your existing structure file, so saved it beforehand if that matters to you. Your current file might not be up to date if the DBA added or removed extents and didn't run prostrct list afterward.

 

[cj_brandt]

strings is a unix util
strings unifipc.db | grep unifipc

If you have a db extent appearing in the .db file that is no longer part of the database - you might have botched an OS copy of the database at some point. You can create a new .db file with the builddb command.

 

[Joe20171]

To List:

Puzzle solved,
It turned out that the source DB was corrupted, we had to delete and recreate unifipc.db.
Later, we tested the same procedure using another database as source, it worked out perfectly without any issue.

Joe