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?
Increasing the LOB size.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute