Recent IT Questions

1 - 7 of 7
<<PREVIOUS 1 NEXT>>

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


1 - 7 of 7
<<PREVIOUS 1 NEXT>>