MySQL Forums - IBM DB2

"Regarding the Installation Issue" (no replies)

Zain Zain — Mon, 30 Oct 2023 13:49:26 +0000

"I changed the job CCSID to (37), and then I received the following message:
mkdir: 001-2128 Error encountered while creating the directory /QOpenSys/MySQL/data. This path or directory does not exist.
13: Could not create a new data directory.
Press ENTER to close the terminal session.

Then I executed the following commands:
mkdir /QOpenSys/MySQL
mkdir /QOpenSys/MySQL/data

Now I'm getting the following message:
mkdir: 001-3016 usage: mkdir [-p] [-m mode] directory ...
/tmp/install.sh: 001-0019 Error encountered while searching for the 'error_exit' command. This path or directory does not exist.
/tmp/install.sh: 001-0055 Error encountered while creating the file --basedir=/usr/local/install.log. This path or directory does not exist.
Press ENTER to close the terminal session.

mkdir: 001-2128 Error encountered while creating the directory /QOpenSys/MySQL/data. This path or directory does not exist.
13: Could not create a new data directory.
Press ENTER to close the terminal session."

Migrating DB2 table with BLOB to MySQL (no replies)

engram GmbH — Tue, 08 Sep 2020 11:48:23 +0000

Hi,

I am trying to migration a DB2 database (v 11.1) to MySQL. I have tried using DBConvert (https://dbconvert.com/db2/mysql/) which works quite well for "normal" tables but fails at a large table (130 GB) with LOBs.

Is it possible to migrate this LOB table in another way? Is it possible to do a

db2 export ...

so that the result is readable for a mysqlimport?

Or is there any other 3rd party tool that is proven to be able to migrate such a large table?

IBM DB2 migrate (Lift & Shift) to MySQL Cloud Service (1 reply)

Mark Boyd — Wed, 19 Aug 2020 13:16:13 +0000

HI,

I need to understand capabilities, best practices for migrating IBM DB2 version 9 (on-prem) to Oracle MySQL Cloud Service. Does anyone have experience or recommendations?

thanks,

-Mark

DB2: 4 different Code Bases? (no replies)

Edwin Desouza — Wed, 07 Feb 2018 01:50:48 +0000

DB2: 4 different Code Bases?
http://perspectives.mvdirona.com/2017/12/1187/

dotConnect for DB2 - New Member of ADO.NET Providers Family (no replies)

Dmitry Nikolaenko — Fri, 16 Aug 2013 10:30:25 +0000

Devart unveils the first version of dotConnect for DB2, an enhanced ORM enabled data provider for DB2 with advanced Entity Framework support. Based on ADO.NET technology it introduces a complete solution for developing DB2-based database applications.

dotConnect for DB2 allows developers to easily integrate DB2 data with widely used data-oriented technologies and use them in .NET applications. The provider offers better Entity Framework support, more features for ASP.NET projects, native SSIS Source and Destination components, dbMonitor support, and other features.

What makes dotConnect for DB2 stand out:

- ADO.NET Benefits
dotConnect for DB2 supports both connected (DataTable) and disconnected (DataSet) models of data access, provides advanced components, such as DB2Script, etc.

- Entity Framework Benefits
dotConnect for DB2 provides way better Entity Framework support than the standard IBM DB2 .NET Data Provider. It supports all the development approaches - Model First, Database First, or Code First, supports Visual Studio EDM designer, and provides its own visual model designer - Entity Developer - with far more advanced functionality.

- ASP.NET Support
dotConnect for DB2 offers a number of features for ASP.NET projects. It provides an advanced DB2DataSource component for data access and support for ASP.NET provider model.

- Miscellaneous features
dotConnect for DB2 can be used in conjunction with Microsoft Enterprise Library Data Access Application Block, provides native Source and Destination components for data flows in SQL Server Integration Services (SSIS) packages, offers convenient per-component monitoring of database events and other features, not available in the standard provider.

For detailed information about the dotConnect for DB2 features, visit the product page - http://www.devart.com/dotconnect/db2/features.html.

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

Migrate IBM DB2 (9.7) to MSQL (2 replies)

andreas Balg — Wed, 19 Sep 2012 00:01:40 +0000

Is there a Bug in our ODBC-SOurce Setup or in MySQL Workbench - How may I do a simple 1:1 (no views, triggers, stored procedures) DB2 to MySQL:

Workbench (5.2.42 CE) just tells Me the fllwing while trying to reverse engineer the DB:

Opening ODBC connection to DSN=gruppeodb;PWD=XXXX...

Connected

Reverse engineering GRUPPE from None

- Reverse engineering catalog information

- Preparing...

- Gathered stats for GRUPPE

*** WARNING: The schema GRUPPE was not found in the catalog None. Skipping it.

Traceback (most recent call last):

File "C:\Users\aba\Downloads\MySQL Workbench 5.2.42 CE\modules\db_generic_re_grt.py", line 281, in reverseEngineer

total_tables = sum(table_count_per_schema[schema.name] for schema in catalog.schemata)

File "C:\Users\aba\Downloads\MySQL Workbench 5.2.42 CE\modules\db_generic_re_grt.py", line 281, in

total_tables = sum(table_count_per_schema[schema.name] for schema in catalog.schemata)

KeyError: ''

Traceback (most recent call last):

File "C:\Users\aba\Downloads\MySQL Workbench 5.2.42 CE\modules\workbench\wizard_progress_page_widget.py", line 191, in thread_work

self.func()

File "C:\Users\aba\Downloads\MySQL Workbench 5.2.42 CE\modules\migration_schema_selection.py", line 160, in task_reveng

self.main.plan.migrationSource.reverseEngineer()

File "C:\Users\aba\Downloads\MySQL Workbench 5.2.42 CE\modules\migration.py", line 329, in reverseEngineer

self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)

SystemError: KeyError("('',)"): error calling Python module function DbGenericRE.reverseEngineer

*** ERROR: Reverse engineer selected schemata: KeyError("('',)"): error calling Python module function DbGenericRE.reverseEngineer

Failed

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.