clmates
Reputable Poster
Hi to all.
We are in Oneworld XE SP 23 J. As part of our upgrade plan we must change our database from MS SQL 7.0 to IBM DB2 UDB 8.2.
We have succesfully intalled the database and create the databases and tables using the provided scripts. We have changed the names as shown to avoid errors naming datasources and environments.
Standard Name New Name
OWSH7333 OWSHDB2
PD7333 PD73DB2
PY7333 PY73DB2
DV7333 DV73DB2
PST7333 PS73DB2
We have created a new pathcode PY73DB2 as a copy of PY7333
and a New Database Datasources:
PY7333 - Central Objects DB2
PY7333 - Control Tables DB2
PY7333 - Bussines Data DB2
PY7333 - Versions DB2
pointing to the new databases.
Also we have setup a new Environment PY73DB2 pointing to this new pathcode.
Now the questions?
1. How can i do to change our system datasources from JD7333 to OWSHDB2? (Object Librarian, Data Dictionary, system and server map)
2. is possible to do this task before copying all the environment data to the db2 databases?
3. is there any related documentation to do such task?
4. what is the recomended method to do this change, installation planner?
Many Thanks
We are in Oneworld XE SP 23 J. As part of our upgrade plan we must change our database from MS SQL 7.0 to IBM DB2 UDB 8.2.
We have succesfully intalled the database and create the databases and tables using the provided scripts. We have changed the names as shown to avoid errors naming datasources and environments.
Standard Name New Name
OWSH7333 OWSHDB2
PD7333 PD73DB2
PY7333 PY73DB2
DV7333 DV73DB2
PST7333 PS73DB2
We have created a new pathcode PY73DB2 as a copy of PY7333
and a New Database Datasources:
PY7333 - Central Objects DB2
PY7333 - Control Tables DB2
PY7333 - Bussines Data DB2
PY7333 - Versions DB2
pointing to the new databases.
Also we have setup a new Environment PY73DB2 pointing to this new pathcode.
Now the questions?
1. How can i do to change our system datasources from JD7333 to OWSHDB2? (Object Librarian, Data Dictionary, system and server map)
2. is possible to do this task before copying all the environment data to the db2 databases?
3. is there any related documentation to do such task?
4. what is the recomended method to do this change, installation planner?
Many Thanks