DB2 Database Forum

During the night we replicate multiple tables from a production database to a test database. Due to a server disk space full condition occurring while replication was running, a tablespace was left in 'Load Pending' status. This tablespace has about 20 tables in it. I ran the load/terminate command and have now come to understand that...

Hi there, I got a program to write data to a randomly accessed file (the program moves file pointer to a certain position of the file according the current "keyword" and then writes data). It compiles and runs in Win2K and various Unix and Linux systems. The main program is in Fortran, calling a data writing library writen in C++. The...

I am trying to figure out what options I have for delimiting columns and records in a flat file (ascii) that is to be loaded into db2. I read through some of the documentation and it seems like there is a fixed position method, but I'm not sure if thats the best bet for me. The table I am loading into will have 2 small fiels (like 32 bytes...

I have spent the last 2-3 hours trying to find a way to just list the constraints for a given table (this includes referential - foriegn keys, not just check constraints). I know how to create them, but can I see them, no way. Howz it done people, let me in on the secret. I tried SYSIBM.SYSCHECKDEP but this doesnt show foriegn key...

Hi All, I am trying to a get a trigger retrieved from Oracle to work on DB2 UDB 8.1. I am getting the following error when trying to create the trigger. How would I resolve this? create table dept ( dept# int not null primary key, deptname varchar(30)) @

I'm trying to install "DB2 workgroup Edition" from "Dummies Test Engine DB2 UDB v7.1 evaluation copy" CD, which comes with DB2 fundamentals certification for Dummies for db2 certification exam 512. The following errors occured during installation of db2... Error during installation: C:\PROGRA~1\SQLLIB\bin\iwh2regi.exe 10 DWCTRLDB DWCTRLDB...

Hi, According to the CLI Guide and reference i can use the function SqlDataSources() to get all aliases on the machine the application is running. But i'd like to get all node names and database names . Is that possible? I cannot find any function in the reference wich would be able to do so. The reason i want to do this, is because...

Is a server at ver 8+ necessdary for jdbc type 4 support in DB2?

I have a test database that I have built in a 3 partition (and 3 node) environment. I have defined all the tables so they have the same partition key. The tables (7 of them) form a hierarchical arrangement. The data is all bogus, so I using the generate_unique function to come up with a partitioning key for each record. This is all done...

I'm trying to take an offline backup on Linux to an NFS mounted filesystem. I have no trouble creating files or directories manually in this filesystem. Here's the df -h for it: Filesystem Size Used Avail Use% Mounted on <IPaddressHere - ommitted>:/db2backup 84G 677M 82G 1% /mnt1 Each time I try the backup, no matter what...

DB2 UDB 8.1 on Red Hat Linux 8: Just installed two Linux machines with UDB 8.1. When creating stored procedure, like "create procedure p1() begin end", got error like: SQL0035N The file "P4265487.msg" cannot be opened. Checked /home/db2inst1/sqllib/function/routine, one machine has no sqlproc subfolder there; another has...

Is DB2 Z/OS 8.1 getting CURRENT SCHEMA/QUALIFIER special register finally? This has been a pain for dynamic applications such as java. It's about time that DB2 Z/OS team finally close this asymmetry between dynamic and static options and also close the gap with DB2 for unixes, windows... Can anyone confirm? TIA

Hi, I installed DB2 8.1 Express on the WindowsXP, and when I begin to use it, I found DB2 creates many new folders in C:\Documents and Settings. It creats more and more folders every day. All new folders has name like: "db2admin", "db2admin.MACHINENAME", "db2admin.MACHINENAME.001", "db2admin.MACHINENAME.002", ... Can any one help me with...

We plan for 1 (big) server to host both a production and test database for a system, and some other small db's. Databases to be put on a SAN. But I don't understand the topics concerning installation and administration. What can I do and what can't I do, when multiple databases reside on the same server. Can there be a setup, so that the...

I am unable to see the health monitor SQL table functions (e.g.: SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the functions? DB2 8.1.3.132 WR21324. Another point about the health monitor - when I get notification messages all they say is that a particular instance/db has a warning or alarm. I have to open the health...

Prio to installing FP3 for 8.1 on AIX 4.3 the command LIST APPLICATIONS SHOW DETAIL used to display a timestamp in the "Status Change Time" Column. Since FP3, I get a "Not Collected". As far as I can tell, all switches are turned on now as before. Any suggestions as to where to look before I call IBM support? Thanks, Fred Prose AZ...

I'm used to working with the old reliable Stored Procedure Builder in Version 7. You created a project and made your database connection - just like version 8. Here's where I am running into confusion/issues: I wrote an SQL stored procedure built it and it compiled just fine. I go to the Server View in the Development Center and there it is...

Hi all, Just trying to get a feel here. THe shop I work at insists on prefixing all column names with the table name, so it is order_id in the ORDER table and Customer_id in the CUSTOMER table. I find this irksome and much prefer that a coding standard be imposed whereby any column name has to be qualified by the table name. So it would be...

On the command center how can I select from a table belonging to a different database than I am connected to? I tried to qualify with database name etc and didn't work. Thanks

is it known to work (or a ref that explains the issue) that compiled java classes (from 1.4.X on nt) can be stored as blobs on db2/390, read and executed on websphere/nt?? i've just joined a project, and i'm told that it was tried, but always failed. no further information. i've not seen a thread on the ng discussing this. it would seem...

Hi, Can anyone help me in making the following SQL work ? Basically I am trying to use a computed filed (CASE statement) in group by clause and struggling with syntax (new to DB2) select A, CASE B WHEN 1 THEN 'AAA' WHEN 2 THEN 'BBB' ELSE 'ZZZ' END AS D, sum(C) from TEST group by A, D

Vendors such as ORACLE document how they support the server being configured to provide dead connection detection. I see no documentation in the IBM manuals or support site notes that suggest that DB2 supports this. Do any of the DB2 editions support this and how to you enable it? Note: I am not talking about idle connection management

Hi, According to Application Programming and SQL Guide chapter 29: "If DB2 terminates, a task that issued CONNECT must issue DISCONNECT to reset the CAF control blocks. The function returns the reset accomplished return codes and reason codes (+004 and X'00C10824'), and ensures that future connection requests from the task work when DB2...

Hi, I want to create the following stored procedure on a DB2 8.1 ESE no fixpack running on redhat linux 8.0 (Intel) CREATE PROCEDURE ADMIN.MYREVOKE ( ) MODIFIES SQL DATA BEGIN REVOKE SELECT ON S1.T_EMPLOYEE FROM USER APP1; END

Hi, i tried to write Java STP's on linux with DB2-7.2.5 and getting the error SQL4301N , UC:"0", SQLSTATE=58004. I've also switched KEEP_DARI to no, JDK_PATH11.... and couldn't get them run. SQL-Procedures running well. Tx for Answers.. P.S: JDK J2SE Runtime 1.4.1_02-b06, mixed mode, Suse 8.2, DB2-7.2