MySQL Forums - IBM DB2

IBM DB2 (no replies)

John Mark — Mon, 11 Mar 2013 10:02:51 +0000

Hello members how i can learn the DB2...
is there any book or please give me the link to learn the DB2 from the beginning

how i can save user's email from SQL more than 1000 user (no replies)

mamo best — Fri, 01 Mar 2013 14:50:11 +0000

hi
i'm trying to check users registered to my site and in thSQL server the list can show only 200 rows or 1000, how i can show more because right now. i'm able to check the first 1000 users ....

thank you in advanced
http://www.dubai3dmax.com/

IBM DB2 Installation (no replies)

Nishant Dwivedi — Fri, 07 Dec 2012 05:15:20 +0000

I want to know the scope of IBM DB2 and also want to learn it can anyone suggest me the installation process of this

How to migrate IBM DB2 database to MySQL? (3 replies)

Radjiv Brathmupkali — Fri, 27 Apr 2012 16:16:23 +0000

Hi All,

I need to migrate IBM DB2 database to MySQL. Can you suggest any tools to do this job?

Your help is greatly appreciated,
Radjiv

What is DB2 Certification? (2 replies)

aaron angelle — Fri, 17 Jun 2011 06:36:22 +0000

What is DB2 Certification? From where I can learn.

Please guide me the best institution that is teaching DB2 Certification in the world. Any online tutorial or site where I can get online material. I am not familiar with this program nor i have any idea.

I am waiting for your response because I want to start it immediately.

LinkServer to DB2 (1 reply)

Mihai Serban — Fri, 29 Apr 2011 15:16:25 +0000

Hello everyone!

Im looking into ways to connect MySQL and a DB2 iSeries using ODBC/JDBC. I need to query DB2 from MySQL.
Is this something that can be achieved?

I checked the docs and forums for some time now and could not find any refference to this.

Thanks in advance.

Helo (no replies)

Kamran Ahmed — Sat, 16 Apr 2011 19:01:24 +0000

Gdmwja tjgmdmd

DB2 accessing online news (no replies)

amjad127 ali127 — Thu, 14 Apr 2011 07:41:21 +0000

Welcome to the best Online Newspapers from the entire world, Information on local issues, all politics, Main events, World celebrations, people and all business on onlinenewspapersz.com. Online Newspapers if you are looking for best accommodation, shopping, in free Online Newspapers.
Bargains and about the weather then this is the place to start. Information about Online Holidays, vacations, Online Resorts, real estate and property together with finance, stock market and as well as investments reports in Online Newspapers, also look for theater, movies, culture, Online Entertainment, activities and events all covered in Online Newspapers.

Compare MySQL table with DB2 table (no replies)

Joseph Panico — Thu, 02 Dec 2010 14:01:52 +0000

Hello,

I thought some here might find this helpful. There is a new Open Source tool that can help significantly with the process of migrating between SQL Server and DB2.

http://www.diffkit.org

DiffKit allows you to compare the data in two tables, where one table is MySQL and the other table is in DB2. It gives you very fine-grained control over the comparison (what to compare, what to ignore, tolerances, etc).

savf download? (2 replies)

Darlene Dangel — Fri, 01 Apr 2011 06:21:17 +0000

Is there still a savf download option available for IBM Power i5/os? All documentation I can find is older. I don't see that as an option on the download page? Thank you.

MYSQL to DB2 Migration (2 replies)

hawk sury — Tue, 27 Jul 2010 12:36:13 +0000

Dear All,

I am running the following mysqldump command to backup one of the tables to
DB2.

mysqldump -u root -p --compatible=db2 mydatabase mytable>C:\backup\mytable

It actually works fine and generates a backup file. The problem is that it un-necessarily adds a '\n'prefix to the every first column element of each row.
(Apart from the very first element of the first column)

The output is as following,

Insert into mytable Values (id, europe,100),(\nid2,europe,102),
(\nid3,europe,103) ........... and so on

The \n is added by mysql unnecessarily.
Does anyone know how to stop mysql from putting \n un-necessarily OR
If there is any option in IBM DB2 that can just avoid \n while
loading files.

I would appreciate if you could help.

Thanks for reading,

hawksury

DB2 Technology Explorer (no replies)

hawk sury — Mon, 26 Jul 2010 18:50:20 +0000

Hi,

I am actually running DB2 on Amazon Virtual Instance and accessing DB2 via Technology Explorer web interface.

I am trying to load a CSV file into the table that I created but it is giving an error SQL 46...

I tried both Load and Import commands as
LOAD FROM /home/tc/myfile.del of DEL
INTO TABLE mytable(column1,column2)

It seems like the file path is not understood, I tried putting file inside the Virtual Instance's home directory and then calling it from Technology Explorer but it did not work.
I am not confident if i am correctly pointing it to the directory or file perhaps should be in a specific folder for db2 to pick up (i thought it will pick up the path from /home directory)

Does anybody know how to fix this?

Many Thanks,

Hawk

Compatibility problem of timestamp datatype of DB2 & MySql (1 reply)

Diya S — Mon, 26 Jul 2010 23:23:32 +0000

I am facing compatibilty issue while migrating DB2 to MySql.
As in my database some of the tables have primary key as timestamp column.
While migrating to Mysql,m losing some data(last microseconds part of Db2 timestamp) which further leads to primary key violation.
Please help me out....
Thanks in advance :)

alternate for db2 final table (no replies)

Iftikhar Babur — Thu, 11 Mar 2010 10:56:08 +0000

i have an issue during migration of our existing system from ibm db2 to mysql
i have following query
SELECT * FROM FINAL TABLE (UPDATE users SET last_wrong_tries = 0 WHERE user_id = 'abc')
This works fine in db2 but cant in mysql
i want to know how can i convert this within query!!!

Install problem (2 replies)

Franco Montefusco — Mon, 22 Feb 2010 17:43:42 +0000

I'm working with V5R4M0 following
http://www.itjungle.com/fhg/fhg022008-story01.html
but when I digit
MYSQLINST/INSMYSQL DIR('/usr/local')
DATADIR('/QOpenSys/MySQL/data')
USRPRF(MYSQL)
the install give me the message:
mkdir: 001-3016 usage: mkdir [-p] [-m mode] directory ...
/tmp/install.sh: 001-0019 Errore rilevato durante la ricerca del comando erro
r_exit. Questo percorso o indirizzario non esiste.
/tmp/install.sh: 001-0055 Errore rilevato durante la creazione del file --bas
edir=/usr/local/install.log. Questo percorso o indirizzario non esiste.
Premere INVIO per chiudere la sessione del terminale.
How can I do?
Thank in advanced!
Franco

how can I extract db2 metadata and create a diagram on mysql workbench using that data? (no replies)

roberto rocha — Thu, 03 Dec 2009 17:55:36 +0000

I also need to be able to see the indexes.

Any ideas?

Homework Data Arquitecture 2 (no replies)

hitoshi kanno — Tue, 22 Sep 2009 00:50:51 +0000

Hi my name is hitoshi kain kasimato toriyama, im student from Wiener Vitarte, a university from lima peru, well im looking for information about DB2 and MySql, aplications, whatever you have, pls give it to me soon! I hope you answer really soon, because next week, i have mi exposition, pls give me links, documents, important informatios about these topics, CASES, etc, HELP ME PLEASE! I´m driving crazy with this job.

hitoshi_kamisato@hotmail.com

Need help in accessing IMS DC screens from user point (1 reply)

Jai Sankar Vaiyapuri — Wed, 09 Sep 2009 06:12:05 +0000

Hi,

This is the reply for the posting under subject

'Need help in accessing IMS DC screens from user point'

The below will try to make you understand very basics of IMS DC online environment. I welcome any discussions on IMS.
The following are required to invoke a IMS DC Online screen.
1) As you login to CICS region to invoke CICS Online screen, you will have to login to IMS DC Online region to invoke IMS Online screen.

2) Each IMS DC screen is associated with a transaction code, this is of 6 bytes. Lets assume IMSTRN. Once after successfully logging into IMS online region type the command
a. /IMSTRN  To invoke a IMS DC Screen
3) Remember, at each and every time the screen is invoked the associated application program also, gets invoked and executes and hence the transaction is executed. The IMS online screens can be of three types Menu Screen / Inquiry Screen / Update Screen.
4) The IMS DC screen is defined using MFS. (MFS – Message Format Service), this is coded using assembler language, this is all about defining
1. Screen layout
2. MID (Message Input Descriptor)
3. MOD (Message Output Descriptor)
A MFSGEN has to be done once the MFS is coded completely. At this point, before starting to develop the application program the screen layout that you had developed can be viewed on the IMS terminal using the command /FOR Screen_ModName
Screen_ModName is the name given for MOD definition on MFS
5) Application program may be (COBOL, PL/I) & database may be (DB2/IMS DB) should be developed to use the defined screen.

Also, see the discussion thread running on EXPEAT FOAUM on this topic.

Regards,
Jai-Chennai

Urgent opening -IMS DBA (Bangalore India) (no replies)

munish d — Thu, 03 Sep 2009 12:49:57 +0000

Hi Friends,

We are looking for IMS DBA for one of our esteem client.
Location:- Bangalore INDIA
Exp:- 3 to 7 years
Skills:- IMS (Prod DBA)
Client:- Fortune 500 listed
Intersted candidates may send their profile at munish@credoindia.org

regards,
Munish

store and retrieve BLOB db2 vs mysql (no replies)

nimo mayr — Sun, 19 Jul 2009 19:03:55 +0000

I used db2 to store large BLOBs and described these datatypes as follows:

"blob(209715200) not logged not compact"

my first question:

WHERE (HOW) can I set my blobs in mySQL as "not logged not compact".
Are there any similar keywords for "not logged not compact".
WHERE (HOW) can I set my blobs in mySQL as not compact "not logged not compact"??

In db2, I set these 4 properties to avoid a out-of-memory-exception (heap space) when retrieving the BLOB-File from the database (without the need for changing my java heap space):

fullyMaterializeLobData=true;
fullyMaterializeInputStreams=false;
progressiveStreaming=2;
progresssiveLocators=2;

In mySQL, I have to change the property:
max_allowed_packet = 1G (so my maxBlob can be 1G)

However, in mySQL, I get always a out-of-memory-exception (heap space) when not enhancing my heap space.

so my second question:

Are there any similiar properties in mySQL for ??:

fullyMaterializeLobData=true;
fullyMaterializeInputStreams=false;
progressiveStreaming=2;
progresssiveLocators=2;

create insert query from excel data (no replies)

praveen kumar — Tue, 30 Jun 2009 15:39:49 +0000

Hi All,

i have the table names and the values provided in the excel sheet. Is there any software to create a insert query with the data available in the excel.

Some questions from a newbie! (1 reply)

Mushtaque Asghar Shaikh — Sat, 22 Aug 2009 11:47:56 +0000

Dear All,

I'm totally newbie to MySQL, but having little bit working experience in IBM DB2. There are some certain questions from my side regarding MySQL:
1) Is there any freely available Management Tool like in Control Center for IBM DB2?
2) How clear the screen of MySQL Client (like CLS in DOS)?
3) Is there any freely available GUI Client for MySQL?

Regards,

Mushtaque Asghar

can't migrate from DB2 to MySQL (no replies)

Joanna Grossman — Tue, 13 Jan 2009 18:22:08 +0000

So,

I connect to two LINUX environments (one w/ DB2 and another with MySQL) via a windows machine. On windows I have all the DB2 client stuff and MySQL client stuff. I'm trying to migrate my database from the DB2 to MySQL with the Migration toolkit. I'm using the "Generic Jdbc" option and I can't connect. My settings are:
Class name: com.ibm.as400.access.AS400JDBCDriver
Connection string: jdbc:as400://host/;

What am I doing wrong?!?

TIA

How to get data from MySQL to AS400 (1 reply)

Dave Banerjee — Sun, 26 Oct 2008 15:27:55 +0000

Hello, I have project billing and time tracking system running on AS400 and a PHP Project portal running on a Windows Server.
Could someone help me to understand how I can create a ODBC connection on AS400 to read the data from MySQL database?
Thanks in advance.
Dave.

load data infile (no replies)

junaid khan — Wed, 16 Jul 2008 09:14:45 +0000

Hi
i want to read data from text file which is on ftp server & store it in MySQL DB.
For ex mytextfile contains

data1 data2 data3
data4 data5 data6

all data are tab seprated.i have written below query to read textfile & load it in mysql DB.but it is not aading first fields of each row into database.but as soon as i gave tab on first field also then it is working fine.i m not getting where i m wrong please help.
thnks in adv.

load data infile 'mytextfile.txt' into table mytable FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'

case statement full scan (no replies)

Ananta Pilaka — Tue, 10 Jun 2008 18:14:52 +0000

When we use case statement in sql it makes a complete scan of the table for each row retrieved. How can we get rid of case statement or is there any other way to rewrite the query

Unable to connect to db2 with migration toolkit. (1 reply)

dushyant kumar — Thu, 23 Apr 2009 08:42:33 +0000

Hi All,

While using Migration toolkit we were unable to connect to DB2 database,
The error which we are getting is:
==================Error============================
Connecting to source database and retrieve schemata names.
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :com.ibm.db2.jcc.DB2Driver
Details:
java.net.URLClassLoader$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.net.URLClassLoader.findClass(Unknown Source)
java.lang.ClassLoader.loadClass(Unknown Source)
sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
java.lang.ClassLoader.loadClass(Unknown Source)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source).....................
==================Error============================

The connection specifications are:

Class Name: com.ibm.db2.jcc.DB2Driver,
Connection String: jdbc:db2://10.0.0.208:60000/MYDB:user=MYUSER;password=MYPASS1;

Thnkx in advance
Dushyant

Migration Tool using wrong JDBC driver? (no replies)

andrew miller — Wed, 30 Apr 2008 10:46:51 +0000

I am trying to migrate a DB2 database over to MySQL

Source:
Solaris 8, DB2 SUN64 8.1.6

Destination:
WinXP Pro hosting: Migration Toolkit 1.1.12, MySQL 5.1.23-rc-community, DB2 Client v9.1.401.44

Using the WinXP DB2 client (Control Center) I can connet up to my DB just fine.
Using MS Access and ODBC I can connect up to my DB just fine.

When I try to use the Migration Toolkit I get this error:

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Generic Jdbc
Opening connection ...
Connection jdbc:db2://10.0.0.208:60000/MYDB:user=MYUSER;password=MYPASS1;
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :[ibm][db2][jcc][t4][2043][11550] Exception java.net.ConnectException: Error opening socket to server /10.0.0.208 on port 60,000 with message: Connection refused: connect.
Details:
com.ibm.db2.jcc.b.xb.a(xb.java:375)
com.ibm.db2.jcc.b.xb.(xb.java:76)
com.ibm.db2.jcc.b.a.w(a.java:264)
com.ibm.db2.jcc.b.b.a(b.java:1726)
com.ibm.db2.jcc.c.bb.a(bb.java:375)
com.ibm.db2.jcc.c.bb.(bb.java:340)

In the Migration Toolkit I have Generic JDBC:
Class Name: com.ibm.db2.jcc.DB2Driver,
Connection String: jdbc:db2://10.0.0.208:60000/MYDB:user=MYUSER;password=MYPASS1;

Any thoughts what is going wrong here?

Double Quotes on Field Names (no replies)

ricardo gualberto — Tue, 22 Apr 2008 21:17:47 +0000

I'm working on adding MySQL support to an application that runs on DB2. All table field names defined on DB2 have double quotes on their names and a simple query example will be something like Select "VALUE" from CUSTOMER; .

I would like to do the same query against MySQL in order to don't rewrite a huge amount of code. When I run this same query against MySQL it returns the String VALUE instead of the value stored in the table. Does MySQL support double quotes in a table field as DB2?

MySQL to DB2 Comparision DBMS white papers (no replies)

abhishek a — Tue, 26 Feb 2008 13:00:09 +0000

Hello,

I am curious as to the capabilities of MySQL as an enterprise DBMS and how it compares to DB2 regarding performance, scalability, ease of management, support…the whole gamut. Can you respond with personal beliefs and experiences that anyone there has regarding the subject including any large clients you know that use MySQL and how it is working for them. I welcome all comments.

Thanks