«
»

Database Export Utility

Hello;

There is a little known utility that helps us to export maximo database. This utility helps us to export database in any db type. For example assume that we are using oracle but we want to export database to use it in DB2. We can use this utility. It supplies us a maximo.db2 file which is like we use in maxinst.bat. You can find it in %MAXIMOROOT%\tools\maximo\internal\Unlcvt.bat

Here are the parameters that you can use with this tool:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

Runs psdi.configure.Unlcvt.
The default name of the output file is Unlcvt.ora (Oracle), Unlcvt.sqs (SqlServer), or Unlcvt.ddl (DB2).
The default database is defined in the maximo.properties file.
The commandline parameters for overriding the defaults are listed below.
Also see javadocs for psdi.configure.Unlcvt.
-a (db alias)    Database alias. If not specified, uses mxe.db.url property.
-f (filename)    Filename for properties file.  If not specified, uses maximo.properties.
(Also see -k parameter for propfile directory.)
-k (propfile dir)    Directory for properties file.
(Also see -f parameter for propfile filename.)
-o (filename)    Filename of output file (without path or extension).
-p (password)    Password for database connection.
If not specified, uses mxe.db.password property, or "maximo".
-u (username)    Username for database connection.
If not specified, uses mxe.db.user property, or "maximo".
-x (db platform)    Output to a different db platform that the one being used for input.
(The default is to output to the same platform.)
Values for platform are: 1=Oracle, 2=SqlServer, 3=DB2.

Example Usage:

1

Unlcvt.bat -x3 

  exports database as db2 file….

Have a good day…

Tags: , , , , ,

This entry was posted on Tuesday, February 24th, 2009 at 2:49 am and is filed under Maximo Tips. You can leave a response, or trackback from your own site.

10 Responses

  1. RaiulBaztepo Says:
    March 31st, 2009 at 4:42 pm

    Hello!
    Very Interesting post! Thank you for such interesting resource!
    PS: Sorry for my bad english, I’v just started to learn this language ;)
    See you!
    Your, Raiul Baztepo

  2. advedopomyday Says:
    April 1st, 2009 at 5:42 pm

    Is it very recently reproduce ? Already saw the self info on this locality

    Watch

  3. Imran Says:
    May 18th, 2009 at 11:56 am

    After export to db2 output file, how do you upload to maximo production db2?

    Thanks.

  4. admin Says:
    May 21st, 2009 at 5:14 am

    Hello;

    You can run maxinst.bat to install new db to db2 database…

    Have a good day..

  5. imran Says:
    June 2nd, 2009 at 10:27 am

    I managed to migrate the database using the Unclvt.bat tools in “maximo/tools/maximo/internal folder” and unable to start the Maximo service. When I tried to start the maximo services, the “system#major” error occurred in the “MXService .log”. Can you please checked the log file?

    I am very greatful to you if you can review the log file and provide me some suggestions/pointer what to look for to resove the problem. I appriciate your reply as soon as possible. You can mail to me so that i can sent the log file. Thank you.

  6. plovosmeperer Says:
    November 27th, 2009 at 1:51 am

    Fantastic affair, didn’t thought reading it was going to be so interesting when I klicked at your title with link!

  7. amir samir Says:
    January 19th, 2010 at 12:35 pm

    good topic but it gives this error when using from db2 into sql server:
    Writing Create Index statements
    Writing Update MaxSequence statements
    com.ibm.db2.jcc.c.SqlException: The data type of an operand of an arithmetic function or operation “+” is not numeric.
    at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
    at com.ibm.db2.jcc.c.fg.a(fg.java:1206)
    at com.ibm.db2.jcc.b.gb.g(gb.java:140)
    at com.ibm.db2.jcc.b.gb.a(gb.java:39)
    at com.ibm.db2.jcc.b.w.a(w.java:34)
    at com.ibm.db2.jcc.b.vb.g(vb.java:139)
    at com.ibm.db2.jcc.c.fg.n(fg.java:1177)
    at com.ibm.db2.jcc.c.fg.a(fg.java:1832)
    at com.ibm.db2.jcc.c.fg.a(fg.java:473)
    at com.ibm.db2.jcc.c.fg.executeQuery(fg.java:457)
    at psdi.configure.Util.selectString(Util.java:13306)
    at psdi.configure.Util.updateMaxSequence(Util.java:7153)
    at psdi.configure.Unlcvt.updateMaxSequence(Unlcvt.java:602)
    at psdi.configure.Unlcvt.process(Unlcvt.java:179)
    at psdi.configure.Unlcvt.main(Unlcvt.java:903)
    The data type of an operand of an arithmetic function or operation “+” is not nu
    meric.
    Unlcvt completed with errors

  8. imran Says:
    March 12th, 2010 at 10:05 am

    migration from sql server to db2 using will not work. I have manage to migrate sql server to db2 but require a lot of back hand task. Thanks for the idea. I appreciate it.

  9. Fermin Chervin Says:
    May 2nd, 2010 at 6:07 pm

    cool article i have found some great video @ youtube about it check it out here:

  10. John Says:
    May 6th, 2010 at 1:57 pm

    Hi Burak

    Why not you try out the unlcvt.bat converting Maximo on sql server to db2 and let us know the result.

    Thanks for all your posting and some are very good.

Leave a Reply