Multidimensional hash in DB2
Hello, Can you tell me how are the hash structures for multidimensional data are realized in DB2? 10x ...
db2
What is the Varchar(Max) equivalent for DB2?
In DB2, is there a datatype that allows the string to grow and shrink dynamically like Varchar(Max) in SQL Server? ...
Is it possible for a Perl DBI script to do "buffered inserts" on db2?
Buffered Inserts are a feature of db2 allowing one to get greater insert performance. IBM's documentation describes needing to bind this option to your application. I can't figure out if this is possible to do with the Perl DBI interface, and if it is possible, how to do it. ...
How can I set the current schema for DB2 using Hibernate/JDBC?
I used to use currentSchema=MYSCHEMA; in my JDBC URL connection, but the version of DB2 we're using no longer supports that, showing the error 'The "currentSchema" property is not allowed on the target server'. I've tried using hibernate.default_schema, but it's not automatically adding the schema to my table names. I don't want to set t...
Selected number of records from database in DB2.
Hi All, I have to fetch only 50 records at a time from database(DB2), for this I have been usig Row_Number but now the persons are telling that this Row_Number is not stable and has bugs in it so now I have to write a different querry for the same as I have to fetch only 50 records at a time. so please can any body help me out for the...
DB2 Driver Connection Hanging in Glassfish Connection Pool
We have an intermittent issue around the DB2 used from a Glassfish connection pool. What happens is this: Under situations where the database (DB2 on ZOS) is under stress, our application (which is a multi-threaded application using connections to DB2 via a Glassfish connection pool) stops doing anything. The following are observed: 1...
How to view DB2 Table structure
How to view the table structure in DB2 database Please help me Thanks! in Advance Regards Ambut Bhath ...
log location in db2
where are log file stored in DB2? i am searching for a file with name Updatedb20100604182008.log ...
tomcat db2-jdbc datasource configure
Hi, i'm trying to configure a datasource of an db2 database in tomcat (using eclipse as IDE), but i cant solve the problem, Tomcat trow me the following exception: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.ibm.db2.jcc.DB2Driver' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(...
How to Determine Equality of Two Very Large Tables
Hey guys, I'm using DB2 and I have two tables that have a million+ rows in them. Is there a query I can create that will check the two tables to see if all the values in the two are the same? Or, what is the best way to do this? Thanks, Tyler ...
Expose DB2 data as XML / Query DB2via XML
I have a client who has a sort of data warehouse stored in DB2. For a variety of reasons, the data must remain on this platform. The client is considering implementing an open-source CMS (Drupal) which runs in MySQL. The client needs to be able to execute a bunch of pre-defined queries against the DB2 database from the remote applicatio...
Implicit type conversion in DB/2 inserts?
We're using SQL Inserts to insert some data via a script into DB/2 tables, e.g. CREATE TABLE TICKETS (TICKETID VARCHAR(10) NOT NULL); On my home installation, this statement works fine (note that I'm using an integer which is autoatically cast into a VarChar): INSERT INTO TICKETS (TICKETID) VALUES (1); while at my customer's site I...
SQL Query to truncate table in IBM DB2
Hi, Can any one give me the syntax to truncate a table in IBM DB2. I m running the following command: truncate table tableName immediate; The eror is DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=table;truncate ;JOIN , DRIVER=3.50.152 Message: An unexpected token "table" was found following "truncate ". Expected tokens may in...
How do you get average of sums in SQL (multi-level aggregation)?
I have a simplified table xx as follows: rdate date rtime time rid integer rsub integer rval integer primary key on (rdate,rtime,rid,rsub) and I want to get the average (across all times) of the sums (across all ids) of the values. By way of a sample table, I have (with consecutive identical values blanked out for readabilit...
SQL query to get lowest 2 values of a counted query selection (using db2)?
Hi, Imagine I already have a query that returns the following: Col1 | Col2 ------------ A | 2 B | 3 C | 3 D | 4 E | 8 ... Say I used something like this: select Col1, count ( * ) as Col2 \ from ... where ... order by Col2 \ group by Col1 \ So now, all I want to select are (Col1, Col2) such that it r...
How do I cast a decimal field to a date field in DB2 AS/400 ?
I have a DECIMAL field which contains a date in the AS400 format : 1100614 I have tried : cast (MYDATE as DATE) : can't cast DECIMAL to DATE, DATE(MYDATE) returns null. How do I cast this field in a DATE field ? ...
Side-by-side comparison of data by year in SQL
I have table similar to the following: Year | Product | Value 2006 A 10 2006 B 20 2006 C 30 2007 A 40 2007 B 50 2007 C 60 I would like a query that would return the following comparison Product | 2006 Value | 2007 Value A 10 40 B 20 ...
How do I replicate a table to all nodes in a DB2 DPF instance?
I have a dpf instance with a few large tables, which are partitioned, and a number of small tables which are not. I'd like the small table to fully exist on each node of the partition for performance reasons. How do I make db2 fully replicate these small tables to each node? ...
DB2 amount to word international conversion
Can anyone please help in convert amount from number to words international which should consider all conditions i.e. Billion, Trillion etc. in DB2 database ...
How to view IO statistics in db2
In Sybase, one can view the IO statistics of a query using the follow: set noexec on set statistics io on The allows one to see the total logical IO for a query without actually executing it. Is there an equivalent sort of command for db2? ...