MySQL Forums - IBM DB2

I NEED YOUR HELP PLEASE (no replies)

Gabby Takash — Sat, 21 Nov 2009 14:34:47 +0000

Dear Database Support Professional,

I am Database Administrator and I am writing to ask for your help in responding to a 10-12 minute survey for a degree requirement on relational database support professionals in the USA. Please note that the respondent is completely anonymous. If I don’t get this portion of my degree completed by the end of this semester, then I would have to wait for another year which entails additional costs and time on me. By completing the survey, you will be contributing to research in our field and also there is the satisfaction of having helped a fellow professional and a fellow human being attain his goals. I believe a good turn always bring another in some way in our lives. I therefore kindly beg for your help to a fellow database professional by completing this survey. The link to the survey is provided below. If possible please forward to other database professionals or groups:
http://www.surveymonkey.com/s.aspx?sm=a1JqU7GVt1g6rCkIPyL23w_3d_3d

Thank you earnestly for your kindness.
Gabriel

organic search engine marketing (no replies)

gracy smith — Sun, 04 Oct 2009 04:14:01 +0000

Internet marketing's newest thing is organic search engine optimization. Almost 50% of consumers start the buying process with an online search using Google, Yahoo, or similar. Potential customers are letting the search engine fingers do all the walking these days.
Search engine marketing (SEM) and search engine optimization (SEO) are nothing new. Both of those concepts have been around for a few years. As these disciplines have developed and grown more nuanced it was necessary to distinguish them further and add the organic SEO designation.
Not everyone knows what "organic search" is.
Listings that result from a search that are not paid advertisements are considered to be organic. For instance, when a user types in a term or phrase in the empty Google box what results are some sponsored links and advertisements, usually on the right side of the browser or along the top of the page, and a list of links to various websites, usually on the left side of the browser window. These links could be to news reports, personal blogs, article directories, or many other types of websites. As opposed to being paid advertisements, links make this list due to their relevancy to the search topic or words.
Acording to Google, many more people click through these links than those of the "pay per click" links. Not surprising since most people would rather go to a site that was especially relevant to what they were looking for. Customers are understandably skeptical when it comes to advertising language. They do not want to be manipulated or feel like they are being lied to.
That doesn't mean that paid advertising links are dishonest. Just because a link makes the top of the page in a list of organic search results doesn't mean it can be trusted. In the past it was possible to inflate a page ranking simply by repeating the key words or phrases over and over. This is known as "key word stuffing." It is certainly not a good strategy. Besides, neither Google nor customers are stupid.
Searchers find it helpful to see a brief excerpt or description below the link. This allows for quick scanning of the list to see which link is best. Although all the links are relevant, some will be more relevant than others.
Organic search engine optimization attempts to make the most out of every web page. It is a completely legitimate method that seeks to maximize the impact of content that a business has made available to would-be customers. What good is it to have a great product if knows one knows about it? Good practitioners of this approach will stay on top of how search engines like Google determine where a page should rank in an organic search. It is an ever changing algorithm so just because something was effective last year doesn't mean it will work this year.
Shortcuts or tricks usually won't work for very long. Smart, honest organic search engine optimization will always be more effective.
For more information on Organic Search and Indianapolis SEO , contact the professionals at DeepRipples.com
rl=http://www.davepye.com]humor blog[/url]
organic search engine marketing

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

MySQL for legacy applications (no replies)

Sam Khawse — Sun, 10 Feb 2008 20:46:53 +0000

Hi All,
We need to use MySQL database in ILE RPG programs. We need to utilise capabilities of MySQL as our system doesn't have SQL engine for IBM DB2.
Please let me know if there is any possibility of using MySQL with ILE?

Thanks,
Sam

Force migrate to Lower Case? (no replies)

Felix Planjer — Thu, 13 Dec 2007 15:42:11 +0000

Hi,

I'm migrating from a DB2 database to MySQL.
I've managed to get all the data and structure into the MySQL database, using the migration tool (generic JDBC to MySQL). I run into some problems running the application that is using the database.

As it appears the application that we are running is expecting all tables and columns to be in lowercase.
I the set lower_case_table_names option to 1, so all tables get created with lowercase, but all columns are still created in uppercase.

Is there an option in the migration tool to force everything to be created in lowercase? If not, is there a script or tool that can change all column names to lowercase after the migration?

Regards, Felix

load data infile - fails to load my del (ascii) file (no replies)

lanes balik — Tue, 06 Nov 2007 10:26:55 +0000

hi all,

right now i'm trying to migrate from db2 running under linux to mysql v5.1.

i manage to export out the db2 structure & data into a del (ascii) file.
but when i try to load the data from the del file to mysql table, it generate an error.

below is the load data infile syntax i use =
LOAD DATA INFILE 'C:\\Migration\\del\\TABLE01.del' INTO TABLE TABLE01 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

and below is the sample layout of del file (in the above case is TABLE01.del) =
1,0,"2007-07-31 00:25:12"
2,0,"2007-07-31 14:09:00"
3,0,"2007-07-31 00:00:00"
4,0,"2007-07-31 00:00:00"
5,0,"2007-07-31 00:00:00"

and below is the TABLE01 structure =
FieldName, Type, Null, Primary
------------------------------------------------------
MY_TABLEID, int(11), NO, PRIMARY KEY
CNTS, int(11), NO, NOT PRIMARY KEY
INSERT_DATE, datetime, NO, PRIMARY KEY

the error i encounter is =
ERROR 1292 (22007): Incorrect datetime value: '"2007-07-31 00:25:12".....

i do some trick by trying to remove the qoute sign from "2007-07-31 00:25:12" so the del file become =
1,0,2007-07-31 00:25:12
2,0,2007-07-31 14:09:00
3,0,2007-07-31 00:00:00
4,0,2007-07-31 00:00:00
5,0,2007-07-31 00:00:00

And i do load data infile again with same command =
LOAD DATA INFILE 'C:\\Migration\\del\\TABLE01.del' INTO TABLE TABLE01 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
and it was successful.

to me it is very strange, since i can do a sql insert using "2007-07-31 00:25:12" for example: insert into TABLE01 values (11, 22, "2007-07-31 00:25:12") successfully without any error!!!
in fact, when i use a MySQL Administrator tools, and i export out the data from TABLE01 into CSV, then i found that the structure is exactly the same with del file generated by db2.

do i make any mistake??

or do i need to initialize something before i call
LOAD DATA INFILE 'C:\\Migration\\del\\TABLE01.del' INTO TABLE TABLE01 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' ...?????

Any help is appreciated.
Thank you.

Regards,
Lanes

Automated and replicate AS/400 DB2 data to MySQL (-1 replies)

Barry Erickson — Wed, 10 Oct 2007 06:25:00 +0000

I have a similar request as many others have.

I have an AS/400 running a wholesale distribution package. I am interested in getting data from the AS/400 DB2 via some automated method. JDBC, ODBC or some other means.

1) MySQL is on a linux box for which I can get JDBC or ODBC installed.
2) The AS/400 is on same network subnet.
3) I would like an Opensource solution or even code based solution (Sample of what someone else is doing)
4) I would like to be able to schedule this.
5) This is a partial data set. Tables and columns not the whole DB. (Item Master, Purchase orders, stuff like that)

Any Zen master with an implementation even if with a different application in your environment would fine.

AS/400 DB2 data transfer to MySQL (1 reply)

jimmy berry — Fri, 07 Sep 2007 17:35:22 +0000

I am new to MySQL and trying to do what I consider to be to a easy task. Basically, I want to transfer Item Number and shelf life days from the AS/400 to a file in MySQL everynight. I am having an issue on how to do this. In MSSQL, I was able to use DTS (Data Transfer Service) to accomplish this task rather easy because I could schedule the job. Below are the details of what I am trying to accomplish.

1. Transfer the Item number and shelf life days from DB2 to MYSQL server. Call the MySQL table ItemShelf
2. Run a Stored procedure that will update the shelf life days in MySQL table Items using ItemShelf.

What is the best way to accomplish this and automate it?

Thanks for any help you can provide.

Jimmy

using SolidDB for Mysql (1 reply)

Henrik Hansen — Mon, 18 Jun 2007 22:33:13 +0000

Hi forum!

I am wondering if anyone has experience using the database motor from SolidDB with Mysql. Will it really boost my application or not? What do you say?

H

Requirement for a IMS DBA (no replies)

ilogicnet consulting — Sat, 12 May 2007 19:37:40 +0000

Requirement for a IMS DBA

Location: Columbus,Ohio

Duration: 6 months

Rate: Open

IMS Dba with some Db2 experience,. Candidate must be a solid IMS DBA for sure. This is NOT and Oracle spot

The resource will work with a team of mainframe DBAs, ECD management and GTI Enterprise
Computing towers to deliver world-class, high performance Oracle database solutions.
The resource will support development, day-to-day production, application and corporate IT project initiatives, disaster recovery, and performance tuning.
In addition, will act as a technical resource for IT applications in support of these activities.

--
Thank you
Regards

Kevin

Recruiter

kevin@ilogicnet.com

502-379-5014

www.ilogicnet.com

Very Urgernt - Migration (3 replies)

bijay mishra — Fri, 22 Jun 2007 22:46:48 +0000

I am looking for data migration from universe database into Oracle 9i

Migration from Universe Database by IBM to Oracle 9i database:

Details is as:Universe Command Language 10.0

Reasons for migrating from DB2: people, money and technology. (no replies)

Edwin DeSouza — Wed, 21 Feb 2007 23:13:40 +0000

The reasons I have to migrate from DB2 focus on the simple fact that DB2 UDB can be a weak link in the datacenter. The three issues are simply: people, money and technology.

People.
=======

The lack of DB2/UDB experts is a fundamental problem. I?m referring to people who really have this database down cold. People who can implement best practices, set up optimal configurations, know DB2?s SQL dialect by heart. I think there are virtually no experts who are looking for full-time employment. I have talked to some consultants, but it?s very difficult to find qualified people who are looking for full-time work. If you have a solid DB2 UDB team in place this doesn?t matter that much. It seems that few organizations using DB2 have the staff in place to handle this database. IBM’s acquisition of Informix and short lived push to migrate customers from Informix to DB2 backfired and has left some customers with unsupportable DB2 environments.

MySQL is simpler to configure and manage, has a shorter learning curve, and and with the zealous community supporting MySQL, you can get answers to many questions in minutes. So, when you?re making the decision to grow the expertise you need in house (since it?s so difficult to hire), it?s so much easier with MySQL.

Money.
======

Saving money on DB2/UDB support will actually show ROI in year 1, if you turn off 2 CPUs of DB2 and buy a one server MySQL Network Platinum support contract. MySQL Platinum (the highest service level) is about $5000 per server, not per processor. If you can get enough traction with MySQL and downsize DB2, this will lead to significant savings on a medium SMP machine.

Technology.
===========

MySQL core technology is reliable and solid as a rock, and is in use at many (tens of thousands) of places with diverse hardware, operating systems, applications and transaction rates. MySQL has a strong community helping the core developers build the product and they have a good reputation for quick turn around on bug fixes. MySQL supports a significant portion of the SQL standard, MySQL has replication, clustering, and very high performance. MySQL?s implementation of SPL is close enough to DB2?s implementation that the changes to stored procedures should be straightforward and mechanical. Also, datatypes should be close enough to make the schema changes mechanical. It?s likely that the application changes can be limited in nature. Also, i have not tested this extensively, but the SPL (Stored Procedure Language) used by MySQL is very similar with the DB2 SPL. Also, some of the compelling features of DB2 include support for gigantic multi-note federated databases. I’m not talking about migrating them. Moderate-sized single node databases are the candidates I’m talking about.

O.K., so with all that said, let?s stop reading blog entries and put together some migration plans.

http://zerolatency.com/?p=4

porting db2 client code (C/C++) to mysql (1 reply)

Hans Horn — Fri, 02 Mar 2007 20:56:42 +0000

Group,

I'm in the process going open-source in my database development under windows(cygwin). First thing I was trying to port some db2 client CLI code (C/C++) to mysql. I simply don't seem to be able to figure out what header I need to include instead of . Can somebody pls. help me?

thx,
H.

IMS Vs DB2 (no replies)

Durga Gopalakrishnan — Thu, 08 Feb 2007 12:58:56 +0000

Hi
I am Durga, am into a project of converting IMS to DB2.I've fair knowledge abt DB2 but IMS is compltely new to me. Can anyone get the data types mapping between the two and also help in getting a correct methodology to be carried out for the conversion.

IMS to DB2 mehodology (no replies)

Durga Gopalakrishnan — Thu, 08 Feb 2007 12:55:47 +0000

Hi,
This is durga. Am into a project of converting IMS to DB2. I have a fair knowledge on db2, but IMS is completely new to me. Can anyone help me in getting the data types mapping between the two and also the correct methodology to be carried out for the conversion

seq num generation11 (no replies)

peter — Tue, 19 Dec 2006 02:34:31 +0000

Hi frends
All of u have been really helpful in suggestions..here wud like to ask for one more help

In DB2 STORE PROCEDURES im trying value of sequencely generated number to a variable seqnum which i have to use in the naming convention.
I am trying it this way

CREATE SEQUENCE sample_SEQ
| START WITH 0
| INCREMENT BY 1
| NO MAXVALUE
| NO CYCLE
| CACHE 20;
|
select (NEXT VALUE FOR SAMPLE_SEQ) into seqnum from sample_seq;
|
CAN SOMEONE KINDLY SUGGEST IF I M DOINT IT IN THE RITE WAY OR IS THR NEOTHER WAY TO DO IT... im writing the output of this SQL SP to txt files which would be recognized by their unique seq no...

Thanks in advance.. :)

FTP!! (no replies)

peter — Wed, 13 Dec 2006 05:23:05 +0000

HI all,
Wanted to ask if there is any way to do FTP using DB2 SQL stored procedures.As we can perfrom this FTP using oracle stored procedures.IS there any equivalent procedure to do it in DB2?
Suggestions wud be appreciated
Thanks.