DB2 Database Forum

Hi, I'm trying to create a table with a unique index consits of 5 columns with the datatypes ( VARCHAR(80), VARCHAR(144), VARCHAR(1020), VARCHAR(1020), VARCHAR(1020)). But my create table structure is failing as my primary key length is getting exceeded. But I've defined my page size as 32K. which means I can create an index with a length of...

I need a help on SQL query. I have two tables RESPONSETIME00 & RESPONSETIME02, I need to count the URL’s such that how many times it was requested. I am attaching two tables & the output which I am looking for. Let me know how to get the attached output from the two tables.

Hi, I want to join two files and generate a report but I am facing problem while joining as the common field on which I want to joibn the file is the DATE and it has different attributes in both files. E.g. Date value in file CSLEXLP – 26oct11.—charcter- 7 Date value in FUL46P – 20111026- decimal 8 Can you help me out with this please?

i am trying to call a stored procedure which is in oracle from db2... i have created it in oracle and i'm done with the steps of 1.creating wrapper 2.create server 3.create user mapping also 4.create nickname.... i am able to call tables from oracle in db2.....by using this statement create nickname local schema.nickname for remote...

when i try to get data from db2 to oracle...is there any extra script to be run other den the script which we run when federation process between db2 to oracle.....

I have installed db2 admin client V8.2 on Windows 7 machine and I am trying to connect db2 Database. At the end of the process system flashes error:- SQL10007N Message "-1332" could not be retrieved. Reason code: "5"

Hi, I want to use the load statement in db2 stored procedure. i just want to insert the data from one table to another table using load to increase the performance. I tried using like this it is throwing error BEGIN DECLARE CURSOR_LOAD CURSOR WITH RETURN FOR SELECT * FROM SESSION.TEMP_DATELOAD1 CALL SYSPROC.ADMIN_CMD('LOAD CURSOR_LOAD...

I have a stored procedure to be used in my JAVA code. I know only its name, parameters, and I know that it returns nothing. So, when I say, stmt = cn.prepareCall("{call UpdateAgent (?, ?) }"); stmt.setLong(1, agent); stmt.setDouble(2, amount); rs = stmt.executeQuery(); What is actually returned in 'rs'?

DB2 LUW 9.5 Context : Loaded the data for over 100 tables and all with the identity columns. I can go over all the tables manually and find max and can use the alter table alter column restart command but wondering if there's a possibility to just write a stored proc that will take the input as SCHEMA name and will find the tables with identity...

Hi, We are having 100+ servers on which we are configuring the DSN using DB2 configuration assistant manually. I just need the any vbscript or the CLI commnads with the help of which I can automate this task a little bit. Please give any link & reference manual with which I can write my own script. Thanking you all....

Hi all, We have a DB2 instance running on a virtual machine with Windows Server 2003 and 3.75GB of RAM. Some time since 2010, we started to experience problems with DB2, which the entire instance would "hang" when certain SQL queries are run and the only way we could get it to recover is by restarting the machine. I'm not sure if any update...

Is it possible to create Federated Database Objects Between two Db2 Databases Sitting on Different instances in the same Server. Eg ServerDbS1 Instance_01 Dbs1_01 Dbs1_02 Instance_02 Dbs2_01

We are looking at implementing HADR Solution to our OLTP databases and wanted to check how long does a HADR take to switch from primary to Secondary in real world? I have been reading documentation that it is fast, but the actual time is not mentioned any where. Wanted to see if it is less than 5 minutes or longer than it? Also, wanted to see...

Hi, Is there any possibility of importing oracle dump in DB2

Hi; I have a situation where a query is returning multiple rows for each group. For example :- ID Groups Value Status Modified_Time 1 JAA 190 1 2011-10-14 12.01.23 2 JAA 4354 1 2011-5-23 11.01.23 3 JAA 343 1 2011-7-01 11.01.24 4 MTT 566 1 2011-10-01 12.01.25

I have a table, like this: PatNo TranCde TranAmt 1000 Adj1 -250 1000 Adj2 -100 1000 Pmt1 300 1000 Pmt2 700 2000 Adj1 -450 2000 Adj2 -75

I want to convert this (date field) '2011-09-27 14:23:58.078000' to '2011-09-27T14:23:58.078' in DB2 appreciate your help. Thanks

I need to run store procedure for data processing. During data processing, I need to show some messages / information to a log file / screen, how can I do it? Can I use DBMS_OUTPUT.PUT_LINE in the store procedure ? If so, how to set the "Set serverouput on" inside the store procedure ? Thanks !

Hi, Why is it that this command doesn't work in DB2. I have to create a view in which one of the columns has to be null(Don't ask me why that should always be null, because the view in Oracle and DB2 should have same columns and Oracle view has col as null) So i try ... Create view......null as col.......

Hi All, I am not able to connect to DB2 database from java, no matter what driver I use. I either get "No suitable driver found" for Class.forName("com.ibm.db2.jcc.DB2Driver"); OR For Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");

When trying to load the data from a clob data type I get the following error: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1047096368 bytes) What I don't understand is why so much memory is being used. This is a test record that contains only 50 characters yet it is somehow trying to allocate several...

I have a Table that Contains 2 Columns, A & B I need to check Column A for a specific value and if it does not equal that value, Add a new record (INSERT ?) using the specific Value for Column A and existing Value from the checked record for Column B

How to load a table from 2 mainframe flat files with same record length 130 bytes?But these 2 files will have different data on same positions of each file.Any suggestions?ideas..pls..

Hi, I wander if i can write INSERT statment, which selects data from table that exists in database1 into table that exists in database2? If yes - what syntax should i use? It is so simple in TSQL... but does not work in DB2. Thanks in advance! Eka

Good afternoon, I've a question regarding converting Oracle SQL Statement to Microsoft Access. I need to monitor DB's and I would getting data into MS Access direct. I've installed ODBC driver and got connection to Oracle DB's. Now when I trying to get data from Oracle DB (like tablespace size, free space etc) I'm getting error, because I took...