DB2

• DB2 Questions

• • Where is alter table..drop column

    It has been four years since this email thread was created. Has DB2added the "drop column" feature y...

    By ashokrathi_yahoo_com

  • administrative API

    Hi,I wonder if anyone already made a wrapper to attack the administrative APIwith delphi.thanks for ...

    By paul

  • [DB2/AS 400] no available conversion for the sourc...

    Hey there!Please help me...I've got a iSeries (AS 400 with DB2), and I must connect to this dat...

    By grzesiek

  • "Auto number" within a combination key

    Hey all,In DB2 v9 is it possible to have an auto generated number field within a primary key that is...

    By barbk

  • Wrong number of parameters. SQLSTATE =07001

    I'm using Visual Basic 6.0 to update a DB2 database.As I know we can either use .Addnew method ...

    By monkey723

• • Why after RUNSTATS the performance degrated

    Hi ,We have db2v7.2 Aix4.3recently I used db2look and db2move and reloaded data from production to t...

    By m_ras, 7 Comments

  • 805 in Db2

    There is a problem with a DB2 COBOL program. This program has a cursor to read a Db2 tabl...

    By subatra, 1 Comments

  • "... WHERE (a, b) != (1,2) AND (a,b) != (1,3) ...

    Hi.I would like to retrieve all records from a table except these wherethe (a, b) combination has on...

    By usenet_kikobu_com, 3 Comments

  • Comparing with larger value.

    I have a table with a attribute which i set it to varchar(20),for example,create account(username va...

    By desmondtanck, 5 Comments

  • Reorgchk cannot clear * on F3

    DB2 8.2 on AIX for SAPHey there,I'm trying to reorg the tables and indexes as best they can be ...

    By meehange, 2 Comments

• DB2: is the Category's subject.It's has 28,575 questions,this is No.1,429 pages.
• Migration path -> Unidata V6 to DB2 V8.2
• Hello allA client of ours is using IBM Unidata (U2 product line) V6 and nowwants to migrate away to something more dynamic. When I say dynamic Imean industry recognized and able to support a development environmentthat is specifically .NET and C# orientated.The current choices that they are look...
• 1000101011, Wed, 17 Mar 2010 18:57:00 GMT, 2,203 bytes, 5 Answer
• CLI without ODBC
• Hi all,I'm developing a C++ application that needs to communicate with DB2. Itseems that the only way to do that, according to the IBM documentation,is with the CLI API.The problem with this API is that it needs an ODBC datasource to beconfigured, and I want to avoid this because it makes t...
• steingold_gmail_com, Wed, 17 Mar 2010 06:02:00 GMT, 839 bytes, 1 Answer
• Can I put DB2 into maintenance mode for --
• Can I put DB2 into maintenance mode to keep all connections closedexcept the instance owner?.DB2 7.2--LIGHTNING NEWSNewsgroup access for as little as $5 per monthPrivate & Anonymous!LIGHTNING fast Unscensored Downloads!ALL THE NEWSGROUPS at www.lightningnews.com...
• willardfarwark, Wed, 17 Mar 2010 01:38:00 GMT, 375 bytes, 2 Answer
• "snap_get_tbsp" which cannot be accessed
• Hi,I get the following error when trying to view tablespaces in control center.after installing Alternate fixpack and upgrading from UDB 8.1 FP6 (AIX) toUDB 8.1 FP13.[IBM][CLI Driver][DB2/6000] SQL0444N Routine "*GET_TBSP" (specific name "SNAP_GET_TBSP") is implemented with code in library or p...
• zarierb, Wed, 17 Mar 2010 01:21:00 GMT, 588 bytes, 3 Answer
• RAID vs isolated spindles
• Helpful folks,I am trying to find any doc or research or studies comparing the prosand cons of architecting a DB2 disk subsystem to physically segragateindex access and data access on separate spindles, as opposed toputting both index and data on one RAID group and assuming thestriping will prov...
• scav, Wed, 17 Mar 2010 00:35:00 GMT, 530 bytes, 8 Answer
• "export" db2 database
• hi folks,I created a db2 database in db2 personal edition and I want to "export" this database (tables, constraints and data from tables) to an another machine which has installed also db2.It is that possible in db2?I see that I can generate DDL for an existing database, but this is not enough f...
• mihai, Wed, 17 Mar 2010 00:35:00 GMT, 402 bytes, 4 Answer
• where to buy udb 8.2 express
• We're looking to buy db2 udb 8.2 express ("stinger") but the only placeI have been able to find it for sale is directly through IBM. Is ittoo new for other vendors to have it? I wouldn't think so. I can findother versions of udb for sale, but we're specifically looking for 8.2.Any...
• 935main_gmail_com, Wed, 17 Mar 2010 00:35:00 GMT, 334 bytes, 3 Answer
• alter table activate not logged initially
• hi, i found that in alter table command , you can do activate notlogged initially to help not log any changes made to the table to logfile, cause i have to delete almost 1 million records and my logfilsizis 6120 pages, with 15 log primary and 20 log seconday, but still runwith log file full erro...
• xixi, Wed, 17 Mar 2010 00:35:00 GMT, 670 bytes, 1 Answer
• very different costs for select and update - why?
• simple queryselect * from "Result" res where (res."QID" = 51541 or res."QID" =51542)works fine ("SRV-BL"."Result" ~ 900000 rows) and returns 36 rowsbut update - no!update "SRV-BL"."Result" res set "Status"=0 where (res."QID" = 51541or res."QID" = 51542)Exec Time: 2.394387 secondsNumber of Agents...
• bughunter_ru, Wed, 17 Mar 2010 00:35:00 GMT, 2,304 bytes, 1 Answer
• Xemacs & DB2 CLP (W2K)
• FWIW I finally figured out how to get sql-db2 mode to work under xemacswithout having it insert a blank line between every line of output. Hereare the relevant lines from init.el:(setq auto-mode-alist (cons '("\\.sql$" . sql-mode) auto-mode-alist))(setq auto-mode-alist (cons '("\\.ddl$...
• brucemacdonald, Tues, 16 Mar 2010 21:33:00 GMT, 2,267 bytes, 1 Answer
• Who to Import PostGRESQL 7.2.2 database into Db2 7.2
• Hi teamIs there any easy way to Import PostGRESQL 7.2 which is on the Linuxmechine to a DB2 UDB 7.2 on WIndows. What Options do i have.ThanksUgra--Message posted via http://www.dbmonster.com...
• ugrasenaviadbmonster_com, Tues, 16 Mar 2010 16:15:00 GMT, 287 bytes, 1 Answer
• RAID 5 DISKS
• What cmd do I run to check the number of disks I have.Jan M. Nelken wrote:>I would consider this as:> Raid 5 on n disks = (n-1) DATA disk and PARITY disk.>So if I have $aid5 array on 5 disk - I would consider that my DB2 has 4>Data disks. OI know that parity chunk alternates between...
• vishnu, Mon, 15 Mar 2010 18:27:00 GMT, 551 bytes
• YYYYMM "between" selection on date column?
• Hi there,we're currently convert an old ISAM application to Java and DB2.Among the load of problems we found the reports which have user selections like "select all data between mm/yyyy and mm/yyyy".Means: if the user enters "10/2004 - 10/2005" everything between "2004-10-01" and "2004-10-3...
• berndhohmann, Mon, 15 Mar 2010 10:16:00 GMT, 1,199 bytes, 16 Answer
• YYYYMM "between" selection on date column?
• Hi there,we're currently convert an old ISAM application to Java and DB2.Among the load of problems we found the reports which have user=20selections like "select all data between mm/yyyy and mm/yyyy".Means: if the user enters "10/2004 - 10/2005" everything between=20"2004-10-01" and "2004-...
• bernd_hohmann, Mon, 15 Mar 2010 04:47:00 GMT, 1,443 bytes, 9 Answer
• [IBM][JDBC Driver] CLI0622E Error accessing JDBC administration service extensions.
• I have installed DB2 V7.2 twice now and I keep getting the error:"[IBM][JDBC Driver] CLI0622E Error accessing JDBC administrationservice extensions."I see that this is a fairly common error but I have yet to find out howto modify the "CLASSPATH" per some of the replies. Please direct me...
• frank_dms_systems_com, Mon, 15 Mar 2010 03:25:00 GMT, 496 bytes
• [IBM][JDBC Driver] CLI0601E
• Hi !My dev team is getting this error when they run big load program :COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0601E Invalidstatement handle or statement is closed. SQLSTATE=S1000..The application runs fine when they run small loads. I checked the Db2client FP..its on DV2 V8 FP10.Any...
• roger, Sun, 14 Mar 2010 17:17:00 GMT, 366 bytes, 9 Answer
• XBSA client/application
• Hello,I would also like to find the source for an XBSA client orapplication (i.e. links against an XBSA library) so I can betterunderstand the XBSA API, function call sequence , etc.Vasili...
• vasya, Sun, 14 Mar 2010 17:17:00 GMT, 204 bytes, 1 Answer
• XML Extender: trace control file (dxxEnableColumn, 38X03)
• 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 -...
• holger444, Sun, 14 Mar 2010 15:15:00 GMT, 2,265 bytes
• [DB2 Mvs] describe alternative
• I can't use 'describe' command on mvs shell and I don't remember the SQL statement that get the types and dimension of columns... Have you any idea?By!Fabio...
• petitof, Sun, 14 Mar 2010 10:02:00 GMT, 191 bytes, 4 Answer
• " select * from sysibm.sysdummy1 where; ". Hmm...
• IMHO, statements like this is mistake typically.May be more better made this construction - I said about empty WHERE -invalid? A lot of data will saved... :-)Andy...
• bughunter_ru, Sun, 14 Mar 2010 08:05:00 GMT, 182 bytes, 3 Answer
• «««14191420142114221423142414251426142714281429