Install

  1. dataPumper.zip entpacken, z.B. nach /java/dataPumper bzw. C:\java\dataPumper
  2. Datenbanken in dataPumper.properties eintragen
    # GLOBAL PARAMETER
    # Number of Database Entries (no limit)
    NumberofDataBase = 3
    # Debug Mode, more Output! 
    Debug = false
    # Default SMTP-Server
    smtp = myMailHost
    #DB PARAMETER
    #Example for IBM i (AS400)
    # # DB-Entry 1
    # # Driver Settings
    # JDBCClassPath1 = com.ibm.as400.access.AS400JDBCDriver
    # ConnectString1 = jdbc:as400:myAS400-HOSTNAME;use block insert=true;date format=iso;time format=iso
    # # Login Information
    # Username1 = myusername
    # Password1 = mypassword
    # # Database Product, values: db2/i, mysql, mssql
    # DB-Typ1 = db2/i 
    # # Database Entry Name 
    # DB-Name1 = MYAS400_DB
    #Example for MySQL 
    # DB-Entry 2
    # # Driver Settings
    # JDBCClassPath2 = com.mysql.jdbc.Driver
    # ConnectString2 = jdbc:mysql://MYMYSQL-HOSTNAME:3306?useServerPrepStmts=false&rewriteBatchedStatements=true
    # # Login Information
    # Username2 = myusername
    # Password2 = mypassword
    # # Database Product, values: db2/i, mysql, mssql
    # DB-Typ2 = mysql
    # # Database Entry Name 
    # DB-Name2 = MYMYSQLDB
    #Example for MSSQL 
    # DB-Entry 3
    # # Driver Settings
    # JDBCClassPath3 = net.sourceforge.jtds.jdbc.Driver
    # ConnectString3 = jdbc:jtds:sqlserver://MYMSSQL-HOSTNAME
    # # Login Information
    # Username3 = myusername
    # Password3 = mypassword
    # # Database Product, values: db2/i, mysql, mssql
    # DB-Typ3 = mssql
    # # Database Entry Name 
    # DB-Name3 = MY-MSSQL

Die weiteren Schritte sind nur für IBM i (AS400) Benutzer die das CL-Command nutzen möchten!

  • dataPumper Ordner ins IFS nach /java kopieren.
  • AS400 Terminal Sitzung starten.
  • Q-Shell öffnen (qsh eintippen und Enter drücken)
  • Install Script starten,  sh /java/dataPumper/install-cmd.sh
  • Q-Shell wieder verlassen und das CL-Command mit „dataPumper/dataPumper“ + F4 testen.
  • Einsetzen und Spaß haben…

Schreibe einen Kommentar