db2look cuts longs procedures
I use db2look to export my DDL. But it cuts off long procedures. I use the following command: db2look -td @ -d DBNAME -z SCHEMANAME -e -c -o dump.sql If I use, for example, Toad for DB2, everything is fine. ...
db2
Creating XA DataSource to DB2 on JBoss
I trying to configure an XA DB2 DataSource, xa-datasource (based on http://community.jboss.org/wiki/SetUpADB2Datasource) using com.ibm.db2.jcc.DB2XADataSource class (local-tx-datasource works using the com.ibm.db2.jcc.DB2Driver). The target server is DB2 Connect V9.7 Actual xa-datasource config: <xa-datasource> <jndi-name>jdbc/DB2S...
Referring to Code in IBM.Data.DB2 makes that Assembly Unavailable to the rest of my Solution
I have a C# console application with three assemblies: Main, Common and Utilities. In a file in the Main assembly, Main.cs, I have the line: using Utilities; In a directory within the Common assembly, I have the DLL IBM.Data.DB2.dll. In the Utilities assembly, I have a source module which accesses said dll. Utilities has a Reference...
Java JPA, How to do Updates to a table without destroy-create?
Hello there, I was learning some JPA to teach to some java friends and I was wondering, how do you handle updates that comes after the creation of the db in JPA? Let's say I have a production environment where there's data that I cannot lose. Some changes comes in and how do I apply that on my production environment? It there a way th...
Slow DB2 connection on .NET
Hi, I'm working on a project where we're gonna fetch data from a DB2 database. I've been testing with both the ibm provider and simple odbc and with both approaches the connection open method is very very slow. If I try doing the same thing with Java and the IBM jdbc driver, it is a lot faster. Does anyone have any tips on how to i...
Fluent NHibernate with DB2 problem
I have a project that is using Fluent NHibernate. When I try to use the DB2Configuration to connect to a DB2 database I receive the following error when trying to build the SessionFactory: "The IDbCommand and IDbConnection implementation in the assembly IBM.Data.DB2 could not be found. " The assembly that is included in my install of I...
How can I convert a timestamp to an ISO formatted date in db2?
For example, if I have a field in the database that has a value of: 2010-10-20-12.00.00.000000 How can I get a numeric that contains '20101020'. So I can do something like this: SELECT * FROM file where date(timestamp) between 20101020 and 20101031 That doesn't seem to work though. Date() doesn't return it in ISO format. ...
DB2 DBA, Data-Warehousing and BI training
I want to take DB2 DBA certification and also want to learn Data-Warehousing and Business Intelligence. I want to know: (1) Whether DB2 DBA certification is demanding or not. I am a .NET developer since last three years and IT experience is even more. I worked on Oracle, MySQL, SQL Server and used DB2 also for some applications. For suc...
jt400 not converting € sign properly
I'm using jt400 to connect to an iSeries Database with CP1148 encoded tables. While the conversion of Umlauts, etc works just fine it happens to fail converting the Euro sign correctly (String displays ¤). Here are my connection properties: blocking enabled=true;block size=30;date format=eur;translate binary=true I also tried adding ...
Help me select RDBMS for a standalone app. Few Concerns.
My app. is in C# 3.5 and MySQL 5.1. It is a Windows based standalone application. It is running successfully since last two years except few issues and that too were later found out to be MySQL bugs. The bug disturbed the real-time reports as it store the same timestamp in two rows. I don't know whether MySQL fixed it or not so I want t...
Order By Columns
Does adding more columns to ORDER BY have a performance penalty? ORDER BY STYLE vs. ORDER BY STYLE, SIZE, COLOR ...
{"Could not create the driver from NHibernate.Driver.DB2Driver."} I am using C#.net
We are using Nhibernate to connect to DB2 database. From my C# application. We are able to connect using Odbc and OleDB driver but we need to connect using IBM DB2 driver (IBM.Data.DB2.dll). We are not able to connect using it. We are getting below error seems NHibernate is not able to create NHibernate.Driver.DB2Driver. {"Could not ...
DB2 creating event monitor
Hello, I'd like to create event monitor on DB2 z/OS 9.2 i have spent a lot of time trying resolve this problem. So i suggest this link: http://www.ibm.com/developerworks/data/library/techarticle/0303kolluru/0303kolluru.html and trying to make this steps: db2 => connect to dbname user username using password db2 => update monitor...