understanding and detecting sql performance situation with abnormal 400 shutdown
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
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
DB2 Views
How to find the number of views for a DB2 table?
Answer Question
| April 26, 2011 10:02 AM
DB2, DB2 Views
How to find the number of views for a DB2 table?
Answer Question
| April 26, 2011 10:02 AM
DB2, DB2 Views
data base files
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
DB2, PF
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
DB2, PF
Windows ODBC driver for IBM DB2 database
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’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
Transform DB2 to XML from AS/400
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
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
AS/400 data mapping with CPYFRMIMPF
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
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
Tables in DB2 z/OS
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
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
copy file to PC
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
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
Conversion of SQL Server 2000 to iSeries DB2 V6R1
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
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
Is a DB on AS400 always DB2 ?
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
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 AS/400 green screen command line?
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
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
CPYTOIMPF –FLDDLM(*TAB) QUESTION
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
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 a select statement is executed, it is taking lot of time and the table is being locked.
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
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
tablespace
when does alter Tablespace trackmod yes become active
Answer Question
| August 3, 2009 3:40 PM
DB2, TABLESPACES
when does alter Tablespace trackmod yes become active
Answer Question
| August 3, 2009 3:40 PM
DB2, TABLESPACES
Mainframe batch DB2 table I-O monitoring
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
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
db2/400
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 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
How to Determine Database Access on AS/400
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 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
DB2 SQL Confusion
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
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
Slow JDBC DB2 Connection
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
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
AS400
In DDS, Unique is file level keyword. Is there any specific key word for field level?
Answer Question
| December 30, 2008 7:11 AM
DB2
In DDS, Unique is file level keyword. Is there any specific key word for field level?
Answer Question
| December 30, 2008 7:11 AM
DB2
