You can use the utility routine BTRANS24 to check whether the prerequisites for transforming a database to the version '004.00' are fulfilled.
You can explicitly ask for a check to be performed using the CHECK-DATABASE statement. In this case, the check can be performed in parallel with the live DBH session. In addition, a check run is always performed implicitly before the database is transformed (TRANSFORM-DATABASE statement).
The following prerequisites must be fulfilled before migration takes place:
The databases to be transformed must be original databases.
The databases to be transformed must have database layout version '002.00' or '003.00', i.e. they must at least be usable in UDS/SQL V2.0.
If this is not the case then the databases must first be transformed using the conversion utility routines from the corresponding UDS/SQL versions (BTRANS20 for use in UDS/SQL V2.0; BTRANSDB for use in UDS/SQL V1.2).An empty database page must be available in the corresponding realm for each DBTT. This is used to store the initial state of the DBTT anchor table.
If this condition is not satisfied, you must provide sufficient space in the realm by performing offline realm extension using BREORG Version 2.3.
The BREORG utility routine Version 2.3 is also available in the current UDS/SQL version. It is a component part of the UDS-SQL-T package and is by default contained in the SIPPRG.UDS-SQL-T.029 library. There is no start command for BREORG V2.3; the utility routine can be started using the following command:/START-EXECUTABLE-PROGRAM FROM-FILE=(LIB=UDS/SQL-T-module-library,ELEM=BREORG)Free pages must also be available in the DBDIR (8 pages) and DBCOM (29 pages) for the DBTTs of PRIVACY-AND-IQF schema and compiler schema.
All the realms in the database must be accessible and attached - in particular DBCOM.
COSSD and HASHLIB are not needed for the transformation.