Hello, I'm working on building out a db2 database from scripts for build verification purposes. Basically we have a set of db2 scripts that were extracted quite a while ago, and we'd like to build out these scripts into a db2 database, so that we can compare against production and make sure that they match. Any thoughts on available...
If you have to use PostgreSQL instead of Oracle or DB2, what feature would you miss the most? I'm specially interested in features which are important for high availability OLTP applications. Thanks! Edit: I'm looking more into technical limitations. Let's assume you have the same level of expertise in PostgreSQL, Oracle and DB2. ...
are there any time based triggers in DB2? ...
Can anybody tell me what are the changes required in Websphere Adminn console due to DB2 version 8 to 9.5 upgrade..?? ...
I am currently writing a Delphi application that runs queries over a DB2 database using ADO. One of the requirements is that the user should be able to define queries using dates, for example "show me all data from the last 60 days" or "show me all data between November 20th 2009 and January 18th 2010". This wouldn't be an issue, excep...
I'm looking at building some data warehousing/querying infrastructure, right now on top of Map/Reduce solutions like Hadoop. However, it strikes me that all the M/R work is just repeating what the RDBMS guys have solved for the last 20 years with parallel SQL databases. Parallel SQL implementations scale reads and writes across nodes, j...
Hi, Can i use Atomic in the parrent procedure as well as in the procedure which the mail procedure calls. My procedure compiles perfectly, but sometimes when I execute it. I receive following error: DB2 Database Error: ERROR [58004] [IBM][DB2/NT64] SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL ...
I have no control over the db schema and need to map two database columns to a single property in my .Net class. The db engine is DB2 The database has columns AUTH_DT of type DATE and AUTH_TM of type TIME. The relevant code follows: public class Authorisation{ ... public virtual DateTime TransactionDate { get; set; } ... } ...
hi is there a good data dictionary tool out there for a db2 database on linux or mac. Could only find some win apps. maybe something wiki like or html generator. Thanks ...
I would like to test a DB2 stored procedure running on an AS400 system. I have the IBM System i Access for Windows installed and can run SQL commands against the DB2 database. My question is: What is the syntax to execute a stored procedure that takes in a parameter and returns a result as an output parameter and print the value to the...
I am in the process of setting up a central build server. The server is responsible to produce the official build artifacts that will be deployed to all environment. For one of the applications there is an build step that writes to a database. At deploy time we would need to run this build step to the appropriate environment. Since it is...
What are advantages of DB2 over VSAM ...
Hello, I have a Java application that runs on Weblogic. The application needs to access a stored procedure in a DB2 data base, therefore a JDBC data source is configured and accessed by its JNDI name. Data source: ClassDriver: com.ibm.db2.jcc.DB2Driver Properties: user=MYUSER DatabaseName=MYDB The following example works as expecte...
I have a situation that I would normally solve by creating a feeder table (for example, every date between five years ago and a hundred years into the future) for querying but, unfortunately, this particular job disallows creation of such a table. So I'm opening this up to the SO community. Today is Jan 29, 2010. What query could I run ...
I have a clustered application that is suffering from database deadlocks. It is a j2ee application using JPA and hibernate. The database is DB2 8.1 on Z/OS is set to page locking (this is a requirement for the company). The problem is that the primary key are generated as a sequence, and will often deadlock while trying to insert reco...
Well, The question explains all, Using DB2mon tool, Is there a way to tell which client is connecting using which type of connection (type 2 jdbc or type 4 jdbc connection)? All of the connections are showing as db2jcc process which is the common driver for both type 2 and type 4. Also if there is a way to find out whether is connection...
I have a 10-node DB2 9.5 database, with raw data on each machine (ie node1:/scratch/data/dataset.1 node2:/scratch/data/dataset.2 ... node10:/scratch/data/dataset.10 There is no shared NFS mount - none of my machines could handle all of the datasets combined. each line of a dataset file is a long string of text, column delimited. The fi...
I'm querying some data from a table in DB2/z which holds hourly data but occasionally skips some hours (if the clients don't send up details for that hour). Since I'm feeding the data straight into a charting tool which needs a query to get the axis data, it sometimes has missing values from the time axis and looks ugly: 23.00 |=== 22....
Hi - I'm working on a DB2 database and trying to get records by effective date. The only catch is the effective date fields are spanned across 4 columns (month, day, century, year). I think I have the date piece figured out in the select but when I add the where clause I'm having problems. (note that I'm using the digits command to pad b...
I got an interview for a DB2 C++ developer internship at IBM. I have the option of doing it over the phone or in person. Which would you recommend? Is it appropriate to say in my reply email "What will be the nature of the interview so I can best prepare for it?" so I can found out just how technical and code-based it will be. But in ge...