DB2 Database Forum

The company was created in dos and now we want to convert it so it will run on 32 bit machines without having to run in a virtual window.

I am attempting to select the first 50 rows only of data and then update two columns and return the resultset of the rows that were updated to my calling application. The procedure below gets the rows and performs the update but does not return the resultset. Can someone explain to me what I am doing wrong that is causing the result set not to be...

hope someone can help me out in this error! thanks alot! EXPORT TO "D:\PROGRA~1\IBM\SQLLIB\WEBCPTAB.IXF" OF IXF MESSAGES "D:\PROGRA~1\IBM\SQLLIB\WEBCPTAB.EXM" SELECT * FROM DB2ADMIN.MCREC Number of rows exported: 1271587 IMPORT FROM "D:\PROGRA~1\IBM\SQLLIB\WEBCPTAB.IXF" OF IXF COMMITCOUNT 5000 MESSAGES...

Hi, I have a ennvironment. which is with 2 Linux box installed with DB2 V9.7,and they both share the data & log file which is in SAN. Now i want to configure clutsering from the instance level.. cos there is not database as of now... when i create any database by default it should be clustered..

1) db2 => rollforward database emasdb stop SQL5035N The database must be upgraded to the current release.SQLSTATE=55001 2)# ./db2imigr db2fenc1 db2inst1 Missing value for token. Missing value for token. DBI1392W The s command is deprecated. The deprecated command is replaced by new command s. Please help me, please provide...

Hi All, I have a problem on "SET INTEGRITY" on one table. I have one script to "SET INTEGRITY" on a table with couple million rows. We run it one time per week afer it's parent table is loaded. The environment is UDB on solaris. The script is the only task running on this database. We have some other database on the same machine under the same...

Hi, we are trying to use CLP tool provided by DB2 client installer to create DB2 database. We followed the following steps 1)Invoked command line processor (CLP) 2) catalog tcpip node DB2_01 remote 10.134.5.10 server 50000 3) create database mynewdb we are getting the below error message. SQL1096N The command is not valid for this node...

When I try to install db2, and I use db2admin as user, I always get an error message : "password too short". In the documentation is said that DB2 shoudld create the user on the system (Vista)even when it does'nt exist. How can I solve the problem ?

I am trying to write a query that does two things. Can select top 1% or top 100% based on a variable. And two does a dirty read. Right now I am doing dirty read with For Fetch ONLY. I want(Think) to add "fetch first 1% rows only for fetch only". I was thinking it may be possible to write the query twice as an A and B query with a fetch top...

how to pass table name in DB2 Procedure. i passed as IN variable. like this CREATE PROCEDURE PROC1 (IN TNAME CHAR (12)) BEGIN UPDATE TNAME P But it throws an error as Category Timestamp Duration Message Line Position Error 11/2/2010 11:50:03 AM 0:00:00.000 DB2 Database Error: ERROR SQL0104N An unexpected token "DECLARE...

Hi, Can someone help me how to call an API. For Example I would like to run db2CfgGet API to get the instance config params. Thanks in advance. Thanks, Panditt

Hi, We have the following issue, DB2 database table that contains a CLOB datatype column. Using DB2 Connect. XML data containing Polish special characters are loaded into this database column. However data is not being displayed correctly when viewed on the database. This is not happening on another environment where we do not have DB2...

Suppose i am receving two records with some timestamp(only date part i am considering) values. I need to insert the whole records between the date in single job. Can anyone help me?

Hi Gurus, My system: DB2 v9.5_FP0 (Windows). I have two questions that I seek help with: 1. I want to create a table using the following: - db2 create table SCHEMA.DBCFG like SYSIBMADM.DBCFG however, I want to add a 'snapshot_timestamp' column. Is it possible to achieve that with the create command above or do I have to perform an...

I need to set up a nightly process that will refresh a database from another database. We have some complicated reports that users are trying to run against our production database that is causing performance issues for the application users. The reports do not need to have real time data. Data as of last night is perfect. We have some scripts...

Hi All, How to convert rows to columns the table is structured like: NO_ID DATE_TRANS SHF ------ ---------- --- 080003 2010-08-21 11 080003 2010-08-22 99

I have a Count IIF statement that needs to be fixed. This is in an unbound txt field in Report1. Report1's Record source is qurReport1 (combined by 2 tbls...tblPosition Data and tblAction Log). Field of the query are... tblPosition Information_ID: ID (Auto #) Position (dropdown from tblPosition Choices) Program Element (dropdown from...

Also, if my fetched internal table has occurs 100 times, how can I tell the last fetch has only 40 rows of data?

Hi there, is it possible to compile a c-based (not C++!) function with the GNU gcc to make it usable as an UDF in db2? I'm stuck with the following problem: When I try to compile the function using the bldxlcudf-skript (with machine-specific variations), I get gcc: unrecognized option '-bE:name.exp' (where name.exp = file with the...

I am calling a .sql file from my shell script. I want to pass a shell variable to the .sql file and use it in my query. employee1.ksh #!/usr/bin/ksh db2 connect to testdb user testuser $deptid = 10 db2 -vsf /home/testdir/query.sql db2 terminate query.sql

Hello, I am trying to restore a DB2 9.1 fp2 backup to another DB2 9.1 fp2 machine, both are on Windows. C:\Program Files\IBM\SQLLIB\BIN>db2 -tvf C:\db2_data\test.db2 UPDATE COMMAND OPTIONS USING S ON Z ON MYDB_NODE0000.out V ON DB20000I The UPDATE COMMAND OPTIONS command completed successfully. SET CLIENT ATTACH_DBPARTITIONNUM 0...

i,m new to db2 database while doing load process i'm getting following error SQL3055N The input file is not a valid PC/IXF file. The length field in the first record cannot be converted to a numeric value.

I want to take an Online backup of DB on one system and restore on other. While doing this I want to ensure I get only the data/structure that was committed till the time backup kicked off. Any data inserted (and may be even committed) after backup kicked off should not come. This has to be a (an automated) daily End of Day process in our...

After DB2 db cleanning successfully , I checked the size of db with GET_DBSIZE_INFO(?,?,?,0) command, but db size did not reduce and also with df -k command, occupied size by filesystem did not reduce.please let me know why?

I dont want to move db2 or restore database, i just want to extract some tables from the backup. IS this possible ? if yes, please let me know how?