Referring to Unlcvt utility in Maximo 7.6
1. Create MAXDEMO.ORA file from the existing DB2 database, using this command under X System: C:\ibm\SMP\maximo\tools\maximo\internal\Unlcvt.bat -oMAXDEMO -x1
2. Install middleware on the Y system designated for the future MAXIMO Oracle system.
3. Install oracle 10g, create maxdata tablespace, maximo user.
4. On Y System, Install Maximo Asset Management with CUSTOM settings, choose to AUTOMATE WEBSPHERE
5. On Y System, Stop WAS Maximo Server after installation completes
6. C:\ibm\SMP\maximo\tools\maximo\en .... Rename maxdemo.ora into maxdemo_original.ora
7. Copy the MAXDEMO.ora file created in step 2 to Y SYSTEM, C:\ibm\SMP\maximo\tools\maximo\en
7.1 optional in my case I edited the maxdemo.ora file created in step 2 (has more than 3700000 lines) and I eliminated all the statements like 'insert into report%'
8. Move the existing log files from C:\ibm\SMP\maximo\tools\maximo\log into C:\ibm\SMP\maximo\tools\maximo\log\1
9. From command prompt, run the MAXINST command under the Y System 'C:\ibm\SMP\maximo\tools\maximo>maxinst -e -sMAXDATA -tMAXDATA'
10. Check doclinks.properties and other customization, edit them, rebuild, redeploy, restart WAS MAXIMO SERVER.
IBM has deprecated its tool UNLCVT for Maximo 7.6
You can download the tool from here
Extract the content, then copy unlcvt.bat and unlcvt.sh to
MAXIMO-SMP\maximo\tools\maximo\internal
Extract Configure zip file and copy the Unlcvt.class to
MAXIMO-SMP\maximo\applications\maximo\businessobjects\classes\psdi\configure
Please follow these steps to convert your database
0. Stop the existing Maximo server on X System (current)
1. Create MAXDEMO.ORA file from the existing DB2 database, using this command under X System: C:\ibm\SMP\maximo\tools\maximo\internal\Unlcvt.bat -oMAXDEMO -x1
2. Install middleware on the Y system designated for the future MAXIMO Oracle system.
3. Install oracle 10g, create maxdata tablespace, maximo user.
4. On Y System, Install Maximo Asset Management with CUSTOM settings, choose to AUTOMATE WEBSPHERE
5. On Y System, Stop WAS Maximo Server after installation completes
6. C:\ibm\SMP\maximo\tools\maximo\en .... Rename maxdemo.ora into maxdemo_original.ora
7. Copy the MAXDEMO.ora file created in step 2 to Y SYSTEM, C:\ibm\SMP\maximo\tools\maximo\en
7.1 optional in my case I edited the maxdemo.ora file created in step 2 (has more than 3700000 lines) and I eliminated all the statements like 'insert into report%'
You can use UltraEdit for the edition of big files more than 2Gb
8. Move the existing log files from C:\ibm\SMP\maximo\tools\maximo\log into C:\ibm\SMP\maximo\tools\maximo\log\1
9. From command prompt, run the MAXINST command under the Y System 'C:\ibm\SMP\maximo\tools\maximo>maxinst -e -sMAXDATA -tMAXDATA'
10. Check doclinks.properties and other customization, edit them, rebuild, redeploy, restart WAS MAXIMO SERVER.
2 comments:
Have you tried this with 7.6? thanks for posting.
this procedure will ensure that your system is up and running using the destination database. you have to do some changes later on to some objects that need human intervention like Saved Queries.
Post a Comment