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??
View Answer
| Mar 1 2008 2:50 PM GMT
| asked by
Gvdsswami
DB2 Implementation, AS/400 DB2, DB2
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...
View Answer
| Jun 8 2005 6:10 AM GMT
| asked by
sbkhole
DataCenter, Data center operations, Physical security
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?Thanks, Luis
View Answer
| May 23 2005 2:52 PM GMT
| asked by
xixones
Data center operations, Disaster Recovery, Security management
Reference book for JCL
What is the best reference book for JCL ?
View Answer
| Apr 26 2005 6:14 AM GMT
| asked by
sadhnm
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
View Answer
| Dec 27 2004 2:35 PM GMT
| asked by
xixones
Database Management Systems, DB2 Implementation, Architecture/Design
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
View Answer
| Dec 27 2004 2:35 PM GMT
| asked by
xixones
Database Management Systems, DB2 Implementation, Architecture/Design
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??
View Answer
| Nov 12 2004 5:47 AM GMT
| asked by
pperry
AS/400, Hardware, DB2
