Need help in understanding and detecting situation with logical files built for sql rpgle performance and abnormal shutdown. Our system went down due to ups failure. All of a sudden the rpgle sql program is a resource hog because it is not selecting the lf that was built specifically for performance issues. LF is intact [...]
Answer Question | June 5, 2009 2:32 PM
DB2, RPGLE, SQL, SQL performance
How to find the number of views for a DB2 table?
Answer Question | April 26, 2011 10:02 AM
DB2, DB2 Views
How are the negative values in the packed fields are stored in the PF? How to enter negative data in those fields?
Answer Question | July 30, 2009 5:51 PM
I’m looking for a windows ODBC driver to access a DB2 database on the AS400. Does anyone have a link or suggested vendors?
Answer Question | May 26, 2009 9:24 PM
AS/400, DB2, ODBC drivers
I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client’s web server. I have looked at IBM’s XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something in [...]
Answer Question | November 4, 2010 3:36 PM
AS/400 development, DB2, DB2/400, iSeries development, XML, XML Toolkit for iSeries
We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old [...]
Answer Question | May 7, 2009 2:10 AM
AS/400 data mapping, Copy From Import File, Copy To Import File, CPYTOIMPF, DB2, DB2/400
In which dataset will I be able to find the default tables of DB2 V9 in Z OS
Answer Question | April 26, 2011 4:28 AM
DB2, DB2 Everyplace, Mainframe Datasets, Mobile development, z/OS
I need to know how to copy a native iSeries DB2 file to the IFS in PC file format
Answer Question | April 22, 2009 1:39 PM
ASCII File, DB2, File Transfer Protocols, IFS, iSeries
Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.
Answer Question | October 24, 2009 7:50 PM
DB2, iSeries DB2, SQL Server 2000, SQL Server to iSeries Database, V6R1
Please, I want to know if possible : when we speak about a data base on AS400, exactly a data base used by RPG, is it allways a DB2 database ? Is AS400 a database. Is it the same as DB2/400 ? I hope to be clear enough. Sincerely
Answer Question | November 24, 2010 3:25 PM
AS/400 database, DB2, RPG
How to check db2 version in as400 green screen command line?
Answer Question | April 7, 2009 5:34 AM
AS/400 administration, AS/400 command functions, DB2, DB2/400, Green Screen
Our OS is V5R4. I am using cpytoimpf to import .txt file (tab delimited) to DB2 physical file. If I remove the FLDDLM(*TAB), I get all the records but the fields have overlapped data. If I use the (*TAB) I get one record and errors on the remaining copy.(error code 7) Here is the command [...]
Answer Question | March 25, 2009 6:19 PM
CPYTOIMPF, DB2, DB2 Physical File, V5R4
In DB2 when I’m giving a select statement its taking lot of time, the reason is like the table is a very huge table. As a result some times it is locking the table. Can any one help me for executing the select query with any option which would not lock the table. Thank you [...]
Answer Question | August 6, 2009 12:23 PM
DB2, DB2 query, SELECT statement
when does alter Tablespace trackmod yes become active
Answer Question | August 3, 2009 3:40 PM
Dear Sir or Madam: I can examine the excp counts for flat, VSAM, IMS files in the JCL batch JES JOB Log statistics, both while executing & when job has completed. How do you monitor that I/O for DB2 tables? Thank you, Michael Piccolo
Answer Question | March 23, 2009 2:17 PM
DB2, DB2 Table, I/O Monitoring, JCL
I need add a field in existing Physical file without imacting any thing file? i know CHGPF command but i am not sure about which parameter needs to be update… Please advice…
Answer Question | March 6, 2009 1:15 PM
AS/400 DB2, CHGPF, DB2, Physical File
I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.
Answer Question | March 8, 2009 3:36 PM
AS/400 database, AS/400 Permissions, DB2, DB2/400, iSeries database, JD EDWARDS, JDE
I am failing to understand why the following won’t work SELECT m.index, SUM(d1.amt), SUM(d2.amt) FROM master m, detail d1, detail d2 WHERE m.index = d1.index AND m.index = d2.index AND d2.qalif = 1 GROUP BY m.index I wrote another sql that does work, I just don’t understand why I get higher values on SUM(d2.amt) than [...]
Answer Question | January 9, 2009 4:46 PM
DB2, DB2 SQL, SQL
Hello, Having an issue with a new server we are setting up. The server is Linux RHE 4, running DB2 8.1 and Domino 7.03. Our DB2 databases reside an a separate dedicated DB2 server and are cataloged on our new server. Connections to these databases are working fine using SQL tools and from the server [...]
Answer Question | January 8, 2009 9:12 PM
DB2, DB2 8.1, DB2 8.x, DB2 Performance, Domino 7.0.3, Domino 7.x, JDBC, Linux RHE 4
In DDS, Unique is file level keyword. Is there any specific key word for field level?
Answer Question | December 30, 2008 7:11 AM