Topic profile page for UDB.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: UDB.
Topic "Udb" was discussed 545 times on 158 sites in last 3 months
Started 1 week, 3 days ago (2009-11-04 01:49:00)
by lalit81
hi all..... i need to know where can one get the installation guide for installing db2 udb 9.5 on aix pls guys...any information on this would b really helpful. lalit....
Started 2 weeks, 4 days ago (2009-10-26 15:21:00)
by MZeeshan
I am trying to use import/export feature to import DB2 UDB v9.5 (Unix/Sun Solaris) data into SQL Server 2005 (Standard Edition). ODBC DSN is created using IBM DB2 driver v9.7. However, it is not fetching data in the preview and coming up with unidentified datatypes in data mapping window. Has anyone experience with DB2 data transfer? Signature Regards, MZeeshan
Started 2 weeks, 5 days ago (2009-10-26 07:20:00)
by MZeeshan
I am trying to use import/export feature to import DB2 UDB v9.5 (Unix/Sun Solaris) data into SQL Server 2005 (Standard Edition). ODBC DSN is created using IBM DB2 driver v9.7. However, it is not fetching data in the preview and coming up with unidentified datatypes in data mapping window. Has anyone experience with DB2 data ...
Started 2 weeks, 5 days ago (2009-10-26 02:29:00)
by MZeeshan
I am trying to setup a scheduled data transfer b/w SQL Server 2005 and IBM DB2 UDB v9.5 (Unix/Sun Solaris). I am using the latest IBM ODBC drivers v9.7 (used earlier version v8.1 but same result). The data transfer requirement will eventually be bi-directional although I am currently testing data import into SQL Server from DB2. One of my colleagues, a DB2 DBA, has helped me in setting up ...
Started 2 weeks, 5 days ago (2009-10-25 18:28:00)
by MZeeshan
I am trying to setup a scheduled data transfer b/w SQL Server 2005 and IBM DB2 UDB v9.5 (Unix/Sun Solaris). I am using the latest IBM ODBC drivers v9.7 (used earlier version v8.1 but same result). The data transfer requirement will eventually be bi-directional although I am currently testing data import into SQL Server from DB2. ...
Started 3 weeks, 4 days ago (2009-10-20 08:27:00)
by nal.satish
Hi , We are migrating our database from DB2 z/os to DB2 UDB on UNIX. and cobol on mainframes to AIX cobol on UNIX. We have some cobol Db2 programs that are accessing different Databases how do we code such type of programs in AIX cobol. Do we need to Establish connection for accessing Each Tables e.g Table1 under Database1 Table2 under Database2 While Accessing These ...
Started 2 days, 3 hours ago (2009-11-12 12:05:00)
by ek1975
Hello list, I am a mainframe programmer and we are testing IBM Rational Developer for System z (RDz) here. Currently I have DB2 PE Connect 8.2 installed on my PC to connect to mainframe tables and IBM Content Manager. I can't create any local databases using this version. So I would like to install DB2 Express-C 9.5 or 9.7 on my PC, create the SAMPLE database and complete the RDz exercises....
Started 1 day, 12 hours ago (2009-11-13 02:37:00)
by dr_te_z Registered User
Quote: Originally Posted by ek1975 I've got RDz 7.6 installed. It's very cool, I love it except that it came out like 10 years late! So, you missed mainframe express by Micro Focus the last 20 years..... pitty
Started 5 days, 1 hour ago (2009-11-09 13:17:00)
by Stealth_DBA Registered User
truepavan, without knowing your data or a sample (as sathyaram_s asked for), I can only guess. You may be able to use the LOCATE function to find the starting position of what you are looking for. Then you can use that as the second position of the SUBSTR function.
Started 1 week, 1 day ago (2009-11-05 21:23:00)
by db2girl
I see $N is set during runtime. I have 3 nodes - 0 thru 2: 57097 data DB2 UDB global services sqlzParseNodeExpression fnc (3.3.26.76.0.1) pid 4178008 tid 8074 cpid 8425556 node 0 sec 9 nsec 850915731 probe 1 bytes 11 Data1 (PD_TYPE_STRING,3) String: $N 57098 exit DB2 UDB global services sqlzParseNodeExpression fnc (2.3.26.76.0)...
Started 1 week ago (2009-11-07 13:53:00)
by dr_te_z
Quote: Originally Posted by stratmf Hallo, I have a question about DB2 9.1.6 for LUW: For DB2 UDB V8 for z/OS, an application program can issue a multiple-row insert using static SQL like this: EXEC SQL INSERT INTO DSN8810.ACT (ACTNO, ACTKWD, ACTDESC) VALUES (:HVA1, :HVA2, :...
Started 3 days, 15 hours ago (2009-11-10 23:29:00)
by gqdesi
Thanks for all the responses. I'm using DB2 UDB via DBArtisan 8.0.1 What I forgot to mention earlier is that I want to output the counts/max/min in a table. Ex. ID | TBCreator| TableName | FieldName | DataType | RecordCount| ValueCount | UniqueCount | Max | Min I created a table that currently has: ID (Auto-number), TBCreator, TableName, FieldName, DataType. I'm assuming that I ...
Started 1 day, 6 hours ago (2009-11-13 08:10:00)
by Renegade39
Thankyou again heres the logs All processes killed ========== OTL ========== Registry value HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Explorer\ShellExecuteHooks\\{AEB6717E-7 E19-11d0-97EE-00C04FD91972} not found. Registry key HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{AEB6717 E-7E19-11d0-97EE-00C04FD91972}\ not found. ========== SERVICES/...
Started 1 week ago (2009-11-07 04:17:00)
by guyeatsoctopus
Here we go again. First Run was Combofix (2 different posts, to long): ComboFix 09-11-06.03 - Sayed 11/06/2009 23:46.1.2 - NTFSx86 Microsoft® Windows Vista™ Home Basic 6.0.6001.1.1252.1.1033.18.3316.2480 [GMT -6:00] Running from: c:\users\Sayed\Desktop\FFDL\ComboFix.exe AV: AVG Anti-Virus Free *On-access scanning enabled* (Updated) {17DDD097-36FF-435F-9E1B-52D74245D6BF} SP: AVG Anti-...
Started 4 days, 3 hours ago (2009-11-10 11:18:00)
by M.E.
Hi@all, I think my problem is very specific since I already spent some hours while looking for a solution to it. Im developing a service (C language) running on MS Windows and Sun Solaris which communicates with a IBM z/OS host. For performance reasons I had to integrate direct access to the DB2 instance running on the z/OS host using DB2 Connect and static SQL statements. This is already ...
Started 1 week, 1 day ago (2009-11-06 08:59:00)
by impetej
My guess is that your environment is not set up. I use this in my .profile (provided by DB2 install, assuming your instance owner had a .profile when the instance is created) The following three lines have been added by UDB DB2. if -f /sqllib/db2profile ; then . /sqllib/db2profile fi If for some reason, you don't want it in the .profile you can source the ...
