After this we ran a TABLE FILE to print the segment1 which we changed (using the MASTER we changed) and it looks like REORG did not work. The data of field2 appears in field3 and viceversa i.e. the data hasn't moved.
Please let me know what we are doing wrong. Or rather let us know how to make an existing field, part of the index of a segment.This message has been edited. Last edited by: Kerry,
FCOUS 7.6.1 Z/OS use focus in report generaton as well as in online screens
June 26, 2009, 09:40 AM
GinnyJakes
Hopefully you made a backup of the original file. When you are moving fields around and creating indexes, you need two masters, the old one and the new one. When you run your rebuild, dump from the old master and load into the new one or do a rename of the masters inbetween.
Backing up the original is absolutely mandatory when performing these operations. If you did not make a backup then I suggest that you TABLE off the current version swapping the field contents. Then using your new master, reload the database with a simple modify. If the number of records is high, you might want to do a CREATE FILE with the master with indexes, do the MODIFY with a master without indexes, then do a REBUILD INDEX with the master with indexes.
The other question here is do you want an extra Key field or another field to be indexed ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
June 29, 2009, 09:57 AM
Remya
Ginny, I had taken a backup of the databse before attempting the REORG. Waz, It's is an existing filed of the database that we wanted to make as part of the key.
Well, I ran the REORG DUMP job with the DD REBUILD having DSN catalogued and old master and used this catalogued file in REORG LOAD job using new master. This time, it worked!! When I did a TABLE FILE on the databse, it printed the fields correctly.
Thanks Ginny and Waz..
FCOUS 7.6.1 Z/OS use focus in report generaton as well as in online screens