What are the possible situations where DB2 server FORCES to close the applications connected to it?
Possibile situations where DB server forces to close the applications connected to it? Some of the situations can be : DB2 restart, DB2 stop, DB2 suspend. What else situations in DB2 server forces to close the applications connected to it? Your help is greatly appreciated !
Answer Question
| June 29, 2011 11:00 AM
DB2, DB2 restart, DB2 stop, DB2 suspend, DB2 Universal Database, DB2 Update Query, DBFO, IBM DB2
Possibile situations where DB server forces to close the applications connected to it? Some of the situations can be : DB2 restart, DB2 stop, DB2 suspend. What else situations in DB2 server forces to close the applications connected to it? Your help is greatly appreciated !
Answer Question
| June 29, 2011 11:00 AM
DB2, DB2 restart, DB2 stop, DB2 suspend, DB2 Universal Database, DB2 Update Query, DBFO, IBM DB2
How to limit the number of application connections in DB2?
I want to limit the number of application connections to 1 in DB2 server. And try connecting with 2 applications to check the behavior?
Answer Question
| September 23, 2009 10:54 AM
DB2, DB2 administration, DB2 configuration, DB2 connectivity, DB2 Universal Database
I want to limit the number of application connections to 1 in DB2 server. And try connecting with 2 applications to check the behavior?
Answer Question
| September 23, 2009 10:54 AM
DB2, DB2 administration, DB2 configuration, DB2 connectivity, DB2 Universal Database
DB2 update query giving error STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.
The following sql query in DB2 is giving the exception. What can be the correct query for this in DB2? SQLQuery=update EMP set validityenddate=’01-JAN-07′ WHERE username=’XYZ’ Exception: msg=java.sql.SQLException: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.
Answer Question
| December 4, 2008 1:24 PM
DB2, DB2 Universal Database, DB2 Update Query
The following sql query in DB2 is giving the exception. What can be the correct query for this in DB2? SQLQuery=update EMP set validityenddate=’01-JAN-07′ WHERE username=’XYZ’ Exception: msg=java.sql.SQLException: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.
Answer Question
| December 4, 2008 1:24 PM
DB2, DB2 Universal Database, DB2 Update Query
DB2 and talend
I do get the error below when i try to load table in DB2 iseries through ETL tool Talend [IBM][iSeries Access ODBC Driver]Column 6: CWB0111 – A buffer passed to a system call is too small to hold return data can anyone guide me what could be the error
Answer Question
| July 16, 2008 11:30 AM
AS/400 errors, DB2, DB2 Universal Database, iSeries, Talend
I do get the error below when i try to load table in DB2 iseries through ETL tool Talend [IBM][iSeries Access ODBC Driver]Column 6: CWB0111 – A buffer passed to a system call is too small to hold return data can anyone guide me what could be the error
Answer Question
| July 16, 2008 11:30 AM
AS/400 errors, DB2, DB2 Universal Database, iSeries, Talend
OLE DB using Library List
Hi, Do any one use OLE DB to connect to iSeries? Is OLE DB capable of using Library List provided by Job Description? Because when I used it, I have to specify the library name / schema and object name. Please advice… Thank you
Answer Question
| March 12, 2010 11:49 PM
AS/400, DB2, DB2 Universal Database
Hi, Do any one use OLE DB to connect to iSeries? Is OLE DB capable of using Library List provided by Job Description? Because when I used it, I have to specify the library name / schema and object name. Please advice… Thank you
Answer Question
| March 12, 2010 11:49 PM
AS/400, DB2, DB2 Universal Database
Cannot end RGZPFM on V5R4 (Journaled file)
Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I can delete it and restore it from [...]
Answer Question
| March 8, 2010 8:22 PM
AS/400, AS/400 performance, DB2 Universal Database, ENDJOB, Journaling (Exchange), Recovery, REUSEDLT, RGZPFM, RPG, V5R4
Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I can delete it and restore it from [...]
Answer Question
| March 8, 2010 8:22 PM
AS/400, AS/400 performance, DB2 Universal Database, ENDJOB, Journaling (Exchange), Recovery, REUSEDLT, RGZPFM, RPG, V5R4
bi-directional data synchronization on System i for db2 databases
I would like to know what would be the best ways to have bi-directional data synchronization on System i between db2 databases . What are the best ways to synchronize data between DDS and SQL-defined files that belong to different applications?
Answer Question
| March 7, 2010 5:46 PM
DataPropagator, DB2 Universal Database, System i
I would like to know what would be the best ways to have bi-directional data synchronization on System i between db2 databases . What are the best ways to synchronize data between DDS and SQL-defined files that belong to different applications?
Answer Question
| March 7, 2010 5:46 PM
DataPropagator, DB2 Universal Database, System i
Backward compatibility on OS level V4R4 to V4R3
Have a question on backward compatability. Currently we moved some historical JD Edwards data that was on an AS/400 running OS400 V4R5 to a machine running V4R4. Now, we want to move this to another AS/400 that is running V4R3. Now, from V4R5 to V4R4 we havd no problems. I’m not sure if we can [...]
Answer Question
| October 13, 2007 4:11 PM
DataCenter, DB2 Universal Database, RPG
Have a question on backward compatability. Currently we moved some historical JD Edwards data that was on an AS/400 running OS400 V4R5 to a machine running V4R4. Now, we want to move this to another AS/400 that is running V4R3. Now, from V4R5 to V4R4 we havd no problems. I’m not sure if we can [...]
Answer Question
| October 13, 2007 4:11 PM
DataCenter, DB2 Universal Database, RPG
Source Modified User
Hi All, If 4 users works on in same library in one source file, How could we know which user has modified a source? Thanks Reddy
Answer Question
| December 11, 2007 5:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
Hi All, If 4 users works on in same library in one source file, How could we know which user has modified a source? Thanks Reddy
Answer Question
| December 11, 2007 5:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
AS400
hi, i want to know about the answers of these questions.. 1.) If any data has been deleted from the PF then how can we recover that and what are the limitiations for that. 2.) If in run time user want to choose the Access Path of a PF then how can it be possible.
Answer Question
| December 20, 2007 2:50 PM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security
hi, i want to know about the answers of these questions.. 1.) If any data has been deleted from the PF then how can we recover that and what are the limitiations for that. 2.) If in run time user want to choose the Access Path of a PF then how can it be possible.
Answer Question
| December 20, 2007 2:50 PM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security
Excel Data Transfer Add In
I tried transferring data from a physical file (AS400) using the Excel Data Transfer Add In (Client Access) and am getting cells with unreadable syntax. It appears that a space is being populated with a 4040 string etc. Is there a way to get the information transferred without having to modify the data in Excel? [...]
Answer Question
| June 20, 2007 4:19 PM
AS/400, DB2 Universal Database, Printing
I tried transferring data from a physical file (AS400) using the Excel Data Transfer Add In (Client Access) and am getting cells with unreadable syntax. It appears that a space is being populated with a 4040 string etc. Is there a way to get the information transferred without having to modify the data in Excel? [...]
Answer Question
| June 20, 2007 4:19 PM
AS/400, DB2 Universal Database, Printing
Client Access Data Transfer
I am trying to export a demand report to excel using Client Access Data Transfer. The demand report has been saved in the outque (see below). From what I understand the data to and from the iSeries must be either a database table or source physical file. How do I convert the saved report to [...]
Answer Question
| January 21, 2010 11:50 AM
AS/400, DB2 Universal Database
I am trying to export a demand report to excel using Client Access Data Transfer. The demand report has been saved in the outque (see below). From what I understand the data to and from the iSeries must be either a database table or source physical file. How do I convert the saved report to [...]
Answer Question
| January 21, 2010 11:50 AM
AS/400, DB2 Universal Database
Converting from System 36 to iSeries V5R4
I’ve been landed with a project to convert a System 36 system to iSeries 520 with OS V5.4. I have never worked on a System 36 and do not know where to start. Have looked for some documentation in Red Books but could’nt find anything. Does anyone have something I can use – something like [...]
Answer Question
| April 30, 2012 4:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, RPG, RPGLE
I’ve been landed with a project to convert a System 36 system to iSeries 520 with OS V5.4. I have never worked on a System 36 and do not know where to start. Have looked for some documentation in Red Books but could’nt find anything. Does anyone have something I can use – something like [...]
Answer Question
| April 30, 2012 4:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, RPG, RPGLE
Select last 3 transactions
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= ’12345′ order by TransDate desc. I believe there must be a more effcient way of getting [...]
Answer Question
| May 15, 2008 6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= ’12345′ order by TransDate desc. I believe there must be a more effcient way of getting [...]
Answer Question
| May 15, 2008 6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL
URGENT!!! file field decoder generated on AS/400
REALLY URGENT!!!!!!!!!!!!!!!!!!!!! How can i view the contents of a packaged field? I send an example of the chain. I need to visualize the contents of the little squares: 5 1 91010 491997 9801011L 980101 1 1021023 102 103 100 DTO CARULLA DTO CARULLA DTO CARULLA 0 1 0 11 K 1TQ 15% Q TQ [...]
Answer Question
| May 22, 2007 11:15 PM
Application development, AS/400, DB2 Universal Database
REALLY URGENT!!!!!!!!!!!!!!!!!!!!! How can i view the contents of a packaged field? I send an example of the chain. I need to visualize the contents of the little squares: 5 1 91010 491997 9801011L 980101 1 1021023 102 103 100 DTO CARULLA DTO CARULLA DTO CARULLA 0 1 0 11 K 1TQ 15% Q TQ [...]
Answer Question
| May 22, 2007 11:15 PM
Application development, AS/400, DB2 Universal Database
Tracking Changes to Files
Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. [...]
Answer Question
| August 13, 2007 5:44 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. [...]
Answer Question
| August 13, 2007 5:44 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
Question on LoadAll Subfile.
Hi, How to load more than 9999 records in the case of loadall subfile??? And i don’t want delete previously loaded records. Thanks, Rama Krishna
Answer Question
| March 3, 2008 1:58 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Hi, How to load more than 9999 records in the case of loadall subfile??? And i don’t want delete previously loaded records. Thanks, Rama Krishna
Answer Question
| March 3, 2008 1:58 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Error in a Group of Called Programs
Hi, I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC…….so on…10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this??? Thanks in Advance, [...]
Answer Question
| April 26, 2007 12:16 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
Hi, I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC…….so on…10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this??? Thanks in Advance, [...]
Answer Question
| April 26, 2007 12:16 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
V5R3 to V5R4
my operating system was just upgraded from V5R3 to V5R4. All my cobol programs are compiled with *none commitment control and a target release of V5R3M0. However after upgrading the operating system while executing the programs -913 errors are being encountered. The same programs are getting executed fine on a separate box which still is [...]
Answer Question
| January 8, 2010 12:52 PM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Project management, RPG, RPGLE
my operating system was just upgraded from V5R3 to V5R4. All my cobol programs are compiled with *none commitment control and a target release of V5R3M0. However after upgrading the operating system while executing the programs -913 errors are being encountered. The same programs are getting executed fine on a separate box which still is [...]
Answer Question
| January 8, 2010 12:52 PM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Project management, RPG, RPGLE
Optimizing/Indexing to find last transaction
I’m hoping someone can help me out with this. I’m trying to write a query that will return the last transaction for each item in our warehouse. To do this, I’m using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 [...]
Answer Question
| January 8, 2010 12:03 PM
Application development, AS/400, Database, DB2, DB2 Universal Database, Oracle, SQL
I’m hoping someone can help me out with this. I’m trying to write a query that will return the last transaction for each item in our warehouse. To do this, I’m using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 [...]
Answer Question
| January 8, 2010 12:03 PM
Application development, AS/400, Database, DB2, DB2 Universal Database, Oracle, SQL
