I have a current issue where I have only a few megs of disc space left on a system which houses an application and a DB2 database. The main table currently has 700k rows in it.The problem I have when I try to delete all the data in the table is that the transaction logs fill the disc up and henc...
I have a view that runs on DB2 UDB, SQL server 2000/2005 and ORacle 9i/10g. The same syntax breaks on zDB2. Read the description of the error, but it looks that DB2 UDB has the same limitations like zDB2.How could I fix this statement to run on both zDB2 and DB2 UDB?Thansk a lot for the help, mj...
We are running Z/OS DB2 version 8 - but just in 'compatibility mode'.That is the mode where they don't yet convert the DB2 catalogue.Soon we will be entering 'new function' mode and by then the DB2 catalogue will be converted to the version 8 format.To prepare for this,...
I'm at a client running an application in AIX DB2 v7. I have a requirement to pull data from the AIX DB into a COBOL program running on the mainframe. There is a z/OS DB2 DB running at v8 on the mainframe. I thought that we could use DDF to define the AIX DB2 DB as a remote location to t...
Will the query (in the attachment) perform OK or run like a dog?It will typically execute on a z/OS platform using DB2 v7. Lets assume that the two tables contain anywhere between 10 million to 100 million rows! TB1800 is a view. Once the query is actually executed, will the view selection crite...
Platform: z/890; Enterprise Cobol for z/OS v3r4Hello,We have DB2 Content manager installed recently and it's got a windows interface called EClient. The data on Content Manager is actually stored on the Mainframe.My question is, Is there any way I can access/write data to DB2 Content manage...
I'm playing around with db2 8.1 xml extenders on a win2000 box. I'm trying to see if it will work on our project. The problem is we use XSDs instead of DTDs. Can I insert an XSD instead of a DTD on the DTD_REF table? or how do I get around this?ThanksCarlos...
This is my first post, so I hope I am not infringing on any rules. We are using DB2 os/390 v7. We have several xref tables cross referencing corps, accts, custs, users, and cards. The Java developers have a need to join all tables for all needed data in one join so as to perform only one call an...
I want to query an xmlclob field to return records where the xml document contains specific strings.How can I cast an xmlclob to a char/varchar so that I could use the like predicate?...
Hi Fireinds,Is it possible to directly retrieve data in XML format from a DB2 table ? I heard that it is possible to do so for certain data types. But I don't have any more info regarding this. If anyone has some info or Urls , pls do share it. Many thanks...
I have this stored procedure that takes some xml as input. What I needto is use xml as a table so that I can join other tables to the xmland get information back that matches the criteria.I can use dxxshredxml to put it into a regular table and everythingworks great. but when I try to put it int...
Would like to explore importing/exporting data via XML extensions in DB2 V8 in order to simulate import/export utilities.Essentially we have created Ant Tasks to open JDBC connections to DB2 databases and read ASCII del files partically simulating the import (insert and insert_update operations...
Hello,where is the "trace control file" of the XML Extender located please?I think I need this information in order to attack the following problem:When calling the procedure dxxEnableColumn via JDBC, I get no exception, but the column is *not* enabled for XML and the message code and text are -...