Before you convert a VSAM file, you must establish the target DB2® design. One way to do this is to import your copybook into a spreadsheet. Take each field in turn and specify the DB2 column name and data type.
There are a number of common things that you should look for during this process:
In many circumstances, you may have a common reengineering requirement across a number of different files. For example, you may have a specific format for date fields that require an exit to convert to DB2 DATE format. You can consider writing a generic exit and using it for multiple fields and files. Sample generic exits are discussed in Generic assembler FBEs .