WALLDATA RUMBA File Transfer Function
After upgrading from NT to XP or Win2000, the File Transfer function no longer works. Arpeggio is fine but the File Transfer application error is:[Wall Data][Rumba Data Access]No data source specified; dialog prohibited. SQLDriverConnect…. Maybe there are registry entries missing? How do you connect a data source to File Transfer?

Answer Question   |  December 8, 2004  9:31 AM
Data center operations, DataCenter, DB2, Desktop management applications, Desktops, Development, Graphical User Interfaces, Hardware, i5, Installation, Integration/Connectivity, iSeries, Microsoft Systems Management Server, OS/400, PC/Windows Connectivity, Registry, Servers, Software distribution, Sun, Tech support, Thin clients, Third-party services, UDB for client/server, UDB for iSeries/i5, Unix, Vendor support, Windows, Windows 2000 desktop, Windows client administration and maintenance

Moving spool files from one AS400 to another
I’m having a problem retaining the spool file attributes when I tranfer spool files from one ISeries to another. I can use the SNDTCPSPLF and it retains most of the attributes but does not retain the user and date/time attributes of the original spool file. Any suggestions??

Answer Question   |  November 26, 2009  5:47 AM
AS/400, Backup & recovery, DB2, DB2 administration, DB2 Implementation, Hardware, Installation/Upgrades, Migration, Tech support, UDB for iSeries/i5

Installing Siebel 7.7 on a stand alone machine with DB2
is any one trying to do that ? i have heard that it’s a big hasle. i will be trying to do that shortly in the next couple of days or next week. can any one tell me about the basic steps and permissions or user groups i need to set up ? i am [...]

Answer Question   |  November 23, 2004  12:20 PM
Data analysis, DB2, Development, ERP, Hardware, Tech support

DB2 SQL delete to purge Header/Detail records
I have a Header file with Detail records that belong to it. I need to copy the detail data off to a backup file, delete the detail records where the Header record entered date is greater than xx days from the current date, copy the header data off to a backup file and finally delete [...]

Answer Question   |  November 15, 2004  1:16 PM
DB2, SQL

Cobol, DB2, and DDS
Am finally starting to move S/36 apps to native OS400! How do you use DDS to define repeating data, for example, a table in a file using the OCCURS clause … 05 YTD-SALES OCCURS 12 TIMES PIC S9(8)V99 05 YTD-BUDGETS OCCURS 12 TIMES … I suppose you could just define an area in DDS of [...]

Answer Question   |  October 27, 2004  1:39 PM
COBOL, DB2

DB2/400 SQL Sub Query Performance?
Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD where EVENT in (Select EVENT from INVEHH where (EVHYY*10000 [...]

Answer Question   |  October 20, 2009  8:40 AM
Data warehousing/Business intelligence, Database Management Systems, DB2, DB2 Universal Database, UDB for iSeries/i5

Oracle In Linux
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

Answer Question   |  June 15, 2010  1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS

Db2 to Oracle porting
I am in the process of planning to port a running DB2 instance on an IBM Mainframe to Oracle 9i running on Unix. Has anyone done does this before ? If yes, what should I be looking out for ? Any particular advice ? Thanks and Regards, Debu

Answer Question   |  October 13, 2004  3:37 PM
Database Management Systems, DB2, Oracle

Mainframe sunset
Our user departments have been talking about getting off the mainframe over the last several years. Recently, our CIO informed department heads that we would discontinue the mainframe by the end of 2007. It is possible that these departments could decide, “we really didn?t mean it” and push back, but the mainframe-associated costs need to [...]

Answer Question   |  January 4, 2008  11:36 AM
390, DB2, Mainframe

SQL View over a table with members
Hi all, I have an as/400 table(fileA) with several members, I need to create view that joins this to several other tables but but I need to only target one member in fileA. The other tables are all single member tables. I tried to create an alias over the table and then create the view [...]

Answer Question   |  January 10, 2011  9:42 AM
DB2, UDB for iSeries/i5

Mainframe security / Racf
My first time on ITKE , so please forgive, but why do I not see any RACF/Top Secret/ACF2 related issues? It should be under security, or not ? Thanks Pieter

Answer Question   |  September 29, 2004  9:54 AM
390, DB2, Mainframe, Security management

Error when tried to update the SSOledbGrid connected to with Sybase Server Database
I have a visual basic 6.0 application with connect to Sybase Server 11 with OBDC Driver ?Sybase System 11?. In VB application use ADO 2.8 for update a table with two fields (Integer, Varchar(10)), the SSOledbgrid return error ?16389? to update or add a register. Show error when I tried to update the varchar field. [...]

Answer Question   |  July 16, 2004  3:25 PM
ActiveX, Adaptive Server Enterprise, Database, DB2, Development, Oracle, Servers, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Sybase, Sybase EAServer, Visual Basic

RAID configuration for Oracle database
Presently we have a 9iOracle database sized at approximately 50MEG on an HP-UX 11.11 server on a SAN. Our software app vendor is telling us that we should have the database on RAID 10 for better performance. They have done benchmarking with DB sized at what ours will be in the future. (Multi terabyte). Their [...]

Answer Question   |  August 28, 2008  10:34 AM
DB2, Oracle 9i, Oracle database design, RAID configuration

DB2 Automated Utilities – Vendor selection
We use the IBM utilities suite and our own in-house utilities automation for DB2 v7. Our automated utilities is now draining us with heavy maintenance and since V7, there are still a few holes that could cause us some serious damage if not fixed in the near future. However, with V8, we would definitely have [...]

Answer Question   |  June 4, 2004  11:08 AM
CIO, DB2, IT architecture, MVS, OS/390, OS/390/z/OS, UDB for mainframe, Vendors, z/OS

remotely managing database securly
If I want to work at one place and be able to manage the Oracle 8i database remotely and securly at another place, what should I do or set up? Thanks

Answer Question   |  May 26, 2004  4:48 PM
Database, DB2, Oracle, Oracle 8i