How to Make a portable DB2 Client for Windows
Feb. 16, 2017 | smlee36 | #seneca, #db2, #gui, #dbclient, #usb, #windows10
This is an ultra simple tutorial to make a portable DB2 GUI Client.
A USB drive is suposed to be 'D' drive.
TOC
Make a USB Package
Download Programs
DBVisualizer go to https://www.dbvis.com/download/ Download 'Windows 32-bit (zip archive)'
portable JAVA go to http://portableapps.com/apps/utilities/java_portable Donwload 'Version 8u121 (32-bit) for Windows, Multilingual 39MB download / 156MB installed'
JTOpen JDBC Driver go to https://sourceforge.net/projects/jt400/ Download 'jtopen_9_1.zip'
Install Programs
Create a folder 'usr'.
- Click a Right-Mouse-Button > New > folder and name 'usr'
Install jPortable_8_Update_121.paf.exe
- Click a 'jPortable_8_Update_121.paf.exe'
- Select a language 'English'
Set a Destination Folder 'C:\Users\XXXXX\Downloads\usr\java'
'C:\Users\XXXX\Downloads' is the directory you are working now.
- Extract dbvis_windows_9_5_6.zip
- Click a Right-Mouse-Button > Extract All > select 'C:\Users\XXXXX\Downloads\usr'
- Extract jtopen_9_1.zip
- Click a Right-Mouse-Button > Extract All > select 'C:\Users\XXXXX\Downloads\jtopen_9_1'
* Copy the 'C:\Users\XXXXX\Downloads\jtopen_9_1\lib\jt400.jar' file to 'C:\Users\smlee36\Downloads\usr\DbVisualizer\jdbc\'
- 'usr' folder should look like this
Make a Batch File
- Open a Notepad (Press Windows Key + R, enter NotePad)
- Copy this script
@echo off
cd DbVisualizer
SET EXE4J_JAVA_HOME=java
dbvis-multi.exe
- File > Save to 'C:\Usrs\XXXXX\Downloads\usr\RUN-dbvis.bat'
Setting DBVisualizer
- Run the batch file. 'Run-dbvis.bat'
- Enter 'zeus.senecac.on.ca' > Next
- Select the driver 'DB2 for AS/400 (JTOpen)' > Next
- Set as like
Notes : zeus.senecac.on.ca
Settings Format : Database URL
Database URL : jdbc:as400://zeus.senecac.on.ca;libraries=s10a04c2;
Database Userid : {Your Zeus UserID} DB201XXX
Database Password: {Your Zeus Password}
- Now You connected Zeus Server.
Export Setting file.
- File > Export Settings
- Set a 'Export settings to' as 'C:\Users\XXXXX\Downloads\usr\settings.jar' > OK
Make a Portable Driver
- Copy 'usr' folder to USB drive
Use a USB Package
When you work in another computer such as in Commputing common.
Put your USB into a new computer.
Run a DBVisualizer
Clicn RUN-dbvis.bat
'Cancel' 'New Connection Wizard' window
'Close' 'JDBC Driver Finder' window
File > Import Settings,
Select USB \usr\settings.jar > Open
'Ckeck all setting to import' window > OK
'Confirmation Alert' > Import > Restart
Now, the program is ready to use.