DB2 to Text File Conversion and Transfer
I have craeted a Text File from my AS400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this??

Answer Question   |  March 3, 2008  2:50 PM
AS/400 DB2, DB2, DB2 Implementation, iSeries database

Changing the statement heap parameter on iSeries
Hi, I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error “SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can [...]

Answer Question   |  June 9, 2005  6:10 AM
Application software, Availability, Backup & recovery, CIO, Computer Associates, Data center operations, Database Management Systems, DataCenter, DB2, DB2 administration, DB2 Everyplace, DB2 Implementation, Development, E-business, Hardware, IT architecture, Modeling, Operating system platforms, Performance/Tuning, Physical security, Services, Space/structure, Storage, Tech support, Third-party services, UDB for iSeries/i5, Vendors

reusedlt *yes
Hi, Has reusedlt *yes behavior changed with V5R3? When I add a record to a PF that is reusedlt *yes in V5R2 is uses a record that has been deleted, however when i do the same thing on a V5R3 system it adds a new record rather than re-use one. Anyone run into this before? [...]

Answer Question   |  November 1, 2011  2:52 PM
Backup & recovery, Data center operations, Data mining/analysis, Data warehousing applications, Database Management Systems, DB2, DB2 administration, DB2 Implementation, Disaster Recovery, Hardware, Help Desk, i5, IBM, iSeries, OS/400, Performance/Tuning, Security management, Software Quality Assurance, System monitoring, Tech support, tips and tricks, Tools

Reference book for JCL
What is the best reference book for JCL ?

Answer Question   |  May 5, 2011  6:14 AM
DB2 Implementation

Triggers
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks

Answer Question   |  December 27, 2004  2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools

Triggers
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks

Answer Question   |  October 19, 2009  2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools

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