Is therea tool or a way to export CSV ot text files?
Use the CPYTOIMPF “Copy To Import File” command to copy DB2 files to IFS files. =============================================== Is the app being migrated along with the data? Or are you just looking to decommission the app and store the data for historical reference? The CPYTOIMPF command is a way to put data into a .CSV (or other [...]
View Answer
| November 29, 2009 9:50 PM
AS/400, DataCenter
Use the CPYTOIMPF “Copy To Import File” command to copy DB2 files to IFS files. =============================================== Is the app being migrated along with the data? Or are you just looking to decommission the app and store the data for historical reference? The CPYTOIMPF command is a way to put data into a .CSV (or other [...]
View Answer
| November 29, 2009 9:50 PM
AS/400, DataCenter
How can I split job by determine no. of records ?
Hi, Try OPNQRYF. Nikhil ============================================================== The best answer can’t be determined without knowing why 20000 transactions take too long. E.g., it may be because the transactions are applied against very large files with many logicals that must be updated. Breaking the file up might not make much difference if index maintenance is taking the time. [...]
View Answer
| November 29, 2009 8:08 PM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Hi, Try OPNQRYF. Nikhil ============================================================== The best answer can’t be determined without knowing why 20000 transactions take too long. E.g., it may be because the transactions are applied against very large files with many logicals that must be updated. Breaking the file up might not make much difference if index maintenance is taking the time. [...]
View Answer
| November 29, 2009 8:08 PM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Old system fails with no error or log.
I don’t know HFA, but sopme third-party packeges create work files in QTEMP and/or other libraries that are deleted at EOJ and/or when the user signs off. Also, some apps open a bunch of files at sign-on time. If you do a WRKSYSSTS and the DASD usage is high, this may be a problem. Also, [...]
View Answer
| November 29, 2009 12:39 PM
AS/400, DataCenter
I don’t know HFA, but sopme third-party packeges create work files in QTEMP and/or other libraries that are deleted at EOJ and/or when the user signs off. Also, some apps open a bunch of files at sign-on time. If you do a WRKSYSSTS and the DASD usage is high, this may be a problem. Also, [...]
View Answer
| November 29, 2009 12:39 PM
AS/400, DataCenter
Necessity of a multi-member PF in COBOL
A physical file with multiple members all have the same record format definitions, but the actual data in one member is kept separate from the other members. Every physical file defaults to 1 member during creation. Why do this? 1 example is receving a batch of data in a time stamped member. Each batch is [...]
View Answer
| November 27, 2009 3:54 PM
COBOL, Physical Files
A physical file with multiple members all have the same record format definitions, but the actual data in one member is kept separate from the other members. Every physical file defaults to 1 member during creation. Why do this? 1 example is receving a batch of data in a time stamped member. Each batch is [...]
View Answer
| November 27, 2009 3:54 PM
COBOL, Physical Files
How to find PC CPU utilization and programming efficiency on Windows XP?
hi i want rate exchange cpu pc like http://www.dramexchange.com/ thanks
View Answer
| November 26, 2009 9:27 PM
CPU Utilization, elapsed or execution time, program efficiency, Windows XP
hi i want rate exchange cpu pc like http://www.dramexchange.com/ thanks
View Answer
| November 26, 2009 9:27 PM
CPU Utilization, elapsed or execution time, program efficiency, Windows XP
Dell Poweredge T100 RAID 1 setup
A simple way to find out RAID groups is just install OMSA software from installation CD shipped with the server and chose with storage management option in custom installation. Then see in computer managment above Disk Management there will be another option to manage the storage arrays. Just explored the things for your information.
View Answer
| November 25, 2009 1:46 PM
Dell PowerEdge, Dell PowerEdge T100, RAID, RAID 1, RAID configuration, SBS 2003
A simple way to find out RAID groups is just install OMSA software from installation CD shipped with the server and chose with storage management option in custom installation. Then see in computer managment above Disk Management there will be another option to manage the storage arrays. Just explored the things for your information.
View Answer
| November 25, 2009 1:46 PM
Dell PowerEdge, Dell PowerEdge T100, RAID, RAID 1, RAID configuration, SBS 2003
HOW TO CONFIGURE RAID.
Use atleast 4 HDDs if you are planning for RAID 10 or 01 and if you want to add HDDs in RAID then add in x 2. Can’t use odd number of HDDs in such RAIDS.
View Answer
| November 25, 2009 1:39 PM
HP DL380, HP DL380 G6, RAID Array, RAID configuration
Use atleast 4 HDDs if you are planning for RAID 10 or 01 and if you want to add HDDs in RAID then add in x 2. Can’t use odd number of HDDs in such RAIDS.
View Answer
| November 25, 2009 1:39 PM
HP DL380, HP DL380 G6, RAID Array, RAID configuration
The IT Blog Top 10: Oct. 29, 2009
The most effective and informative <a href=”http://www.fifiland.pl/”>przedszkole Szczscin</a> for finland. Here you can find the impressive information which is helpful for you to select your desire goal.
View Answer
| November 25, 2009 1:06 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
The most effective and informative <a href=”http://www.fifiland.pl/”>przedszkole Szczscin</a> for finland. Here you can find the impressive information which is helpful for you to select your desire goal.
View Answer
| November 25, 2009 1:06 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
The most-watched IT questions this week: Nov. 24, 2009
Is this a question? Is it relevant to post it here in Home > IT Answers > AS/400 > The most-watched IT questions this week: Nov…. just wondering!
View Answer
| November 25, 2009 5:03 AM
AS/400, Channel, CIO, CRM, databse, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Is this a question? Is it relevant to post it here in Home > IT Answers > AS/400 > The most-watched IT questions this week: Nov…. just wondering!
View Answer
| November 25, 2009 5:03 AM
AS/400, Channel, CIO, CRM, databse, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
installing DDM link between two as400, problem when using DDM through IP
I guess DDM/SNA is still supported. You should be able to use SNA over IP. However, IP is preferable. You may have security issues. Check CHGDDMTCPA and check for the password required parameter. Beni ========================================================= If “a remote host refused an attempted connect operation”, then the first thing to do is ensure that the server [...]
View Answer
| November 25, 2009 3:15 AM
AS/400, Backup & recovery, DataCenter, Security
I guess DDM/SNA is still supported. You should be able to use SNA over IP. However, IP is preferable. You may have security issues. Check CHGDDMTCPA and check for the password required parameter. Beni ========================================================= If “a remote host refused an attempted connect operation”, then the first thing to do is ensure that the server [...]
View Answer
| November 25, 2009 3:15 AM
AS/400, Backup & recovery, DataCenter, Security
OVRDBF in JAVA
Execute command OVRDBF MYFILE OTHERMBR where OTHERMBR is the one you wish to insert records into. Do this before doing anything with SQL. ========================================================== An ALIAS might be a good idea, but be aware that it creates a permanent (SQL) object. An OVRDBF might be needed, especially if the member name is variable. If creating [...]
View Answer
| November 25, 2009 2:08 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development
Execute command OVRDBF MYFILE OTHERMBR where OTHERMBR is the one you wish to insert records into. Do this before doing anything with SQL. ========================================================== An ALIAS might be a good idea, but be aware that it creates a permanent (SQL) object. An OVRDBF might be needed, especially if the member name is variable. If creating [...]
View Answer
| November 25, 2009 2:08 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development
HP ML110 G5 server Raid error
Since RAID 1 is an exact mirror, it sounds like corruption may have occured before the drive failed. Remove the failed drive and try booting to the OS. If you still can’t bring the OS back up, restore from backup or repair install the OS Make sure you have the exact same drives for you [...]
View Answer
| November 24, 2009 7:33 PM
Array Configuration Tool, HP ML110 G5 Server, HP Servers, RAID, RAID 1, RAID configuration, Windows Server 2003
Since RAID 1 is an exact mirror, it sounds like corruption may have occured before the drive failed. Remove the failed drive and try booting to the OS. If you still can’t bring the OS back up, restore from backup or repair install the OS Make sure you have the exact same drives for you [...]
View Answer
| November 24, 2009 7:33 PM
Array Configuration Tool, HP ML110 G5 Server, HP Servers, RAID, RAID 1, RAID configuration, Windows Server 2003
ultra320 SCSi to SAS 5/e adaptor cable?
You should take a look at the converter section of your local Fry’s Electronics store, they have most of the converters available, and nobody really advertises them.
View Answer
| November 23, 2009 10:04 PM
Cables, SAS 5/e, SCSI, SCSI Adapter Cable, SCSI controllers
You should take a look at the converter section of your local Fry’s Electronics store, they have most of the converters available, and nobody really advertises them.
View Answer
| November 23, 2009 10:04 PM
Cables, SAS 5/e, SCSI, SCSI Adapter Cable, SCSI controllers
To retrieve data from a remote system
One of my clients used to use Sockets for communicating between an AS400 and a Unix box and that worked very well. I keep meaning to “have a go” with socket programming and have seen a lot of good press on Scott Klement’s tutorial at http://www.scottklement.com/rpg/socktut/index.html Hope it helps Jonathan ================================================ Since there have been [...]
View Answer
| November 23, 2009 8:07 AM
390, Application development, AS/400, AS/400 careers, Backup & recovery, Billing and customer care, Billing Support Systems, CLP, DataCenter, DB2, DB2 Universal Database, Development, Email, IBM Marketing Sound Off, Mainframe, Mobile, Mobile security, Network protocols, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, VoIP, Web development, Wireless, zSeries
One of my clients used to use Sockets for communicating between an AS400 and a Unix box and that worked very well. I keep meaning to “have a go” with socket programming and have seen a lot of good press on Scott Klement’s tutorial at http://www.scottklement.com/rpg/socktut/index.html Hope it helps Jonathan ================================================ Since there have been [...]
View Answer
| November 23, 2009 8:07 AM
390, Application development, AS/400, AS/400 careers, Backup & recovery, Billing and customer care, Billing Support Systems, CLP, DataCenter, DB2, DB2 Universal Database, Development, Email, IBM Marketing Sound Off, Mainframe, Mobile, Mobile security, Network protocols, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, VoIP, Web development, Wireless, zSeries
What would it take for you to jump into cloud computing?
does data’s “mission critical” status give you pause in moving over? – Absolutely. But that said, moving to the cloud is not simply a technical decision. Its a business decision. Technically, the move to the cloud is easy. Pick a fairly reliable vendor, put in SLA requirements and test out the functionality and off you [...]
View Answer
| November 19, 2009 6:26 AM
Cloud Computing, Data center consolidation, Google, Open IT Forum, Storage
does data’s “mission critical” status give you pause in moving over? – Absolutely. But that said, moving to the cloud is not simply a technical decision. Its a business decision. Technically, the move to the cloud is easy. Pick a fairly reliable vendor, put in SLA requirements and test out the functionality and off you [...]
View Answer
| November 19, 2009 6:26 AM
Cloud Computing, Data center consolidation, Google, Open IT Forum, Storage
Why can’t I connect to the Internet through my new GBIC module?
IDF1 patch panel should lead to patch panels in another switch closet and the same with IDF2. You would not connect these two panels to each other. You would need to determine if devices were attached at the other end in the IDF’s. Then connect the appropriate pairs to fiber interfaces on the switch or [...]
View Answer
| November 17, 2009 8:20 PM
AT&T, fiber, Fiber Ports, GBIC, Linksys switch, MDF rack, Network equipment, Networking, Patch panels, Routing and switching
IDF1 patch panel should lead to patch panels in another switch closet and the same with IDF2. You would not connect these two panels to each other. You would need to determine if devices were attached at the other end in the IDF’s. Then connect the appropriate pairs to fiber interfaces on the switch or [...]
View Answer
| November 17, 2009 8:20 PM
AT&T, fiber, Fiber Ports, GBIC, Linksys switch, MDF rack, Network equipment, Networking, Patch panels, Routing and switching
DECFLOAT – Internal Format
Hello, I am not sure what you mean by “visual format.” I will take a guess that you want a floating point number to be returned to your application as a decimal number. Use the DECIMAL function. For example: CREATE TABLE TTEST (F_COL FLOAT); ———+———+———+———+———+———+—– DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 INSERT INTO [...]
View Answer
| November 17, 2009 6:42 PM
DB2, DB2 9, DB2 administration, DECFLOAT, z/OS
Hello, I am not sure what you mean by “visual format.” I will take a guess that you want a floating point number to be returned to your application as a decimal number. Use the DECIMAL function. For example: CREATE TABLE TTEST (F_COL FLOAT); ———+———+———+———+———+———+—– DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 INSERT INTO [...]
View Answer
| November 17, 2009 6:42 PM
DB2, DB2 9, DB2 administration, DECFLOAT, z/OS
what is the difference between CPW interactive and CPW batch? How do i determine both using the System model and proc feat
Interactive vs. batch CPW is an IBM marketing ploy to make customers pay more for interactive performance while trying to stay competitive in the Client/Server market. Your iSeries has a “feature card” that will start eating up CPU cycles if you exceed the interactive CPW level you purchased. If you want to provide the processor [...]
View Answer
| November 17, 2009 6:33 PM
AS/400 hardware, CPW, CPW Batch, CPW Interactive, Procurement
Interactive vs. batch CPW is an IBM marketing ploy to make customers pay more for interactive performance while trying to stay competitive in the Client/Server market. Your iSeries has a “feature card” that will start eating up CPU cycles if you exceed the interactive CPW level you purchased. If you want to provide the processor [...]
View Answer
| November 17, 2009 6:33 PM
AS/400 hardware, CPW, CPW Batch, CPW Interactive, Procurement
Community Announcement: Cash in your Knowledge Points for an Amazon gift card
Ok for redeem my points now
View Answer
| November 16, 2009 8:01 AM
AS/400, CIO, CRM, DataCenter, Development, Exchange, Giveaways, ITKE, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP
Ok for redeem my points now
View Answer
| November 16, 2009 8:01 AM
AS/400, CIO, CRM, DataCenter, Development, Exchange, Giveaways, ITKE, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP
Summer to winter time
I have read on a french site that there is a new feature in V5R3 for hour tuning, in iseries navigator (my connexions / my400 / configuration). it explains that you can work QTIMADJ, make a “smart” hour change (for example request 10 minutes to add 5 minutes), and more interesting, you can choose a [...]
View Answer
| November 15, 2009 1:00 AM
AS/400, DataCenter, Development, Systems management software
I have read on a french site that there is a new feature in V5R3 for hour tuning, in iseries navigator (my connexions / my400 / configuration). it explains that you can work QTIMADJ, make a “smart” hour change (for example request 10 minutes to add 5 minutes), and more interesting, you can choose a [...]
View Answer
| November 15, 2009 1:00 AM
AS/400, DataCenter, Development, Systems management software
