Increasing the LOB size.
Posted: Wed Jan 21, 2015 5:51 pm
We have the requirement of changing the LOB column of a table from 7 MB to 100 MB. but due to technical limitation of COBOL we came to a solution down to change the column to 16 MB only.
While changing the table we are facing so many issues, As mentioned below:
1. When we change the table and create the MDDL to promote it then new components are created like new indexes, tables paces for each part where as in production there is only one component DCLOB .
2. Earlier table have LOB column of size 7 MB and it is need to be change to 16 MB this is the middle column and each time if there is changes in the middle column then the data is truncated. So we have to take the unload of the table and as it is a "different-type-of-table" so data of the table will be in dataset and its "related data" will be in PDS nd we do not have any idea how to load the data into the table.
can someone please guide?
While changing the table we are facing so many issues, As mentioned below:
1. When we change the table and create the MDDL to promote it then new components are created like new indexes, tables paces for each part where as in production there is only one component DCLOB .
2. Earlier table have LOB column of size 7 MB and it is need to be change to 16 MB this is the middle column and each time if there is changes in the middle column then the data is truncated. So we have to take the unload of the table and as it is a "different-type-of-table" so data of the table will be in dataset and its "related data" will be in PDS nd we do not have any idea how to load the data into the table.
can someone please guide?