copying archive tapes from jaguar to LTO5
For a migration project I have to copy 1500 jaguar tapes to LTO5. This is a one time activity so I need a connect a robot with LTO5 drives only a limited time (2 years). What LTO5 robots do support BRMS ? I’ve been looking at Quantum Scalar i500 but Quantum say they aren’t compliant [...]
Answer Question
| June 13, 2012 12:05 PM
BRMS, BRMS Backup, Data migration, LTO5, Tape Backups
For a migration project I have to copy 1500 jaguar tapes to LTO5. This is a one time activity so I need a connect a robot with LTO5 drives only a limited time (2 years). What LTO5 robots do support BRMS ? I’ve been looking at Quantum Scalar i500 but Quantum say they aren’t compliant [...]
Answer Question
| June 13, 2012 12:05 PM
BRMS, BRMS Backup, Data migration, LTO5, Tape Backups
Reorganizing AS/400 Files While Active
I work for a company which is a 24/7 company. I cannot get them tp give up the system for any length of time. As a result, any type of maintenance is almost impossible. My biggest problem is reorganizing our files. I have heard that you can do a reorg while active but you must [...]
Answer Question
| February 10, 2011 2:36 PM
AS/400, AS/400 Record Reorganization, RPG, RPG ILE, RPG IV, RPGILE, RPGLE, V5R4
I work for a company which is a 24/7 company. I cannot get them tp give up the system for any length of time. As a result, any type of maintenance is almost impossible. My biggest problem is reorganizing our files. I have heard that you can do a reorg while active but you must [...]
Answer Question
| February 10, 2011 2:36 PM
AS/400, AS/400 Record Reorganization, RPG, RPG ILE, RPG IV, RPGILE, RPGLE, V5R4
iSeries journal receivers
I have some JRNRCV as QACGJRxxxx which is detach and saved.Can I delete these jrnrcv wihtout have a negative impact on my system ?
Answer Question
| October 6, 2011 1:26 PM
iSeries Journalling, Journal receiver management, Journal Receivers, JRNRCVR
I have some JRNRCV as QACGJRxxxx which is detach and saved.Can I delete these jrnrcv wihtout have a negative impact on my system ?
Answer Question
| October 6, 2011 1:26 PM
iSeries Journalling, Journal receiver management, Journal Receivers, JRNRCVR
Anyone know the monmsg msgid for (No active jobs to display)
I am doing command wrkactjob sbs(mysbs) job(myjob) If the job is not active I will receive the work screen with message (No active jobs to display) Reason: I have a cl that monitors (myjob) in (mysbs). I have the script set to send me an alert if there is no active job found/ or is down… I just would [...]
Answer Question
| February 7, 2011 7:33 AM
AS/400 Active Jobs, AS400 Job Status, MSGID, WRKACTJOB
I am doing command wrkactjob sbs(mysbs) job(myjob) If the job is not active I will receive the work screen with message (No active jobs to display) Reason: I have a cl that monitors (myjob) in (mysbs). I have the script set to send me an alert if there is no active job found/ or is down… I just would [...]
Answer Question
| February 7, 2011 7:33 AM
AS/400 Active Jobs, AS400 Job Status, MSGID, WRKACTJOB
AS/400 user ID which i do not want to be disconnected at all.
I have a user id which i do not want to be disconnected at all. Is that possible since i have set a system value for QDSCJOB. All profiles need to be disconnected if not active for above 15 mins, therafter after another 30 mins the interactive job is ended. But i need this one [...]
Answer Question
| February 9, 2011 3:56 AM
AS/400, AS/400 user administration, AS/400 user permissions, AS/400 user profiles, iSeries
I have a user id which i do not want to be disconnected at all. Is that possible since i have set a system value for QDSCJOB. All profiles need to be disconnected if not active for above 15 mins, therafter after another 30 mins the interactive job is ended. But i need this one [...]
Answer Question
| February 9, 2011 3:56 AM
AS/400, AS/400 user administration, AS/400 user permissions, AS/400 user profiles, iSeries
Setup for Internet public can access the iSeries 170
I have a iSeries 170 running V4R5. It is on a LAN that has Internet access provided by a IP provider. I need to know what is needed so the Internet public can access the iSeries 170 and it HTTP servers that are running. I have run: wrkhdwrsc *cmn System: S105004M Type options, press Enter. [...]
Answer Question
| February 7, 2011 9:16 PM
AS/400 IP address, iSeries, LAN, V4R5
I have a iSeries 170 running V4R5. It is on a LAN that has Internet access provided by a IP provider. I need to know what is needed so the Internet public can access the iSeries 170 and it HTTP servers that are running. I have run: wrkhdwrsc *cmn System: S105004M Type options, press Enter. [...]
Answer Question
| February 7, 2011 9:16 PM
AS/400 IP address, iSeries, LAN, V4R5
Convert Spool File Tools
I am looking at using either Iseries Report Downloader or SpoolIt to convert spool files into an Excel format. Has anyone used these tools? Is there another tool I should look at using? What I want to accomplish is to take a spool file, strip out the page headers, breaks and pick and choose the data [...]
Answer Question
| February 10, 2011 8:55 PM
AS/400 Spool Files, AS/400 Spooled Files, Change Spooled File Attributes, Spool files
I am looking at using either Iseries Report Downloader or SpoolIt to convert spool files into an Excel format. Has anyone used these tools? Is there another tool I should look at using? What I want to accomplish is to take a spool file, strip out the page headers, breaks and pick and choose the data [...]
Answer Question
| February 10, 2011 8:55 PM
AS/400 Spool Files, AS/400 Spooled Files, Change Spooled File Attributes, Spool files
Continue to get the error ’425 Not able to open data connection’ when doing an FTP ‘Put’ from my i Series to my customer’s i Series.
Happens whether I use passive or port mode. Appears the FTP is getting to my customer’s i Series because I see the following message below in their Qsysopr. Any suggestions? Message ID . . . . . . : TCP2617 Severity . . . . . . . : 20 Message type . . . [...]
Answer Question
| February 4, 2011 7:10 PM
AS/400 FTP, FTP, FTP 425 Error
Happens whether I use passive or port mode. Appears the FTP is getting to my customer’s i Series because I see the following message below in their Qsysopr. Any suggestions? Message ID . . . . . . : TCP2617 Severity . . . . . . . : 20 Message type . . . [...]
Answer Question
| February 4, 2011 7:10 PM
AS/400 FTP, FTP, FTP 425 Error
Save IXS CL program
Does anyone out there have a CL program which saves all the objects on an IXS?
Answer Question
| February 7, 2011 7:06 PM
CL Program, CL programming, CLPROGRAM
Does anyone out there have a CL program which saves all the objects on an IXS?
Answer Question
| February 7, 2011 7:06 PM
CL Program, CL programming, CLPROGRAM
*UTCD field type
Hi All, We have just upgraded from V5.4 to V6.1 and have run into a problem with a program that does a sndpgmmsg of CPF1241. The date and time parameters are data types *UTCD and *UTCT. What should be used to populate those parameters when sending the message? Everything I’ve tried so far gives me [...]
Answer Question
| February 24, 2011 2:33 PM
*UTCD, AS/400 Dataset, AS400 Data type, iSeries V6R1
Hi All, We have just upgraded from V5.4 to V6.1 and have run into a problem with a program that does a sndpgmmsg of CPF1241. The date and time parameters are data types *UTCD and *UTCT. What should be used to populate those parameters when sending the message? Everything I’ve tried so far gives me [...]
Answer Question
| February 24, 2011 2:33 PM
*UTCD, AS/400 Dataset, AS400 Data type, iSeries V6R1
How to know if AS/400 data is journaling properly?
How we can know that Data is Journaling proparly or not?
Answer Question
| February 5, 2011 5:50 AM
AS/400, AS/400 Data Reports, AS/400 database administration, AS/400 journaling
How we can know that Data is Journaling proparly or not?
Answer Question
| February 5, 2011 5:50 AM
AS/400, AS/400 Data Reports, AS/400 database administration, AS/400 journaling
I can connect locally to iSeries via telnet
I can connect locally using telnet, but cannot do it from the outside world. Any pointers out there would be appreciated. thanks, Bob
Answer Question
| February 16, 2011 2:50 AM
AS/400 connectivity, iSeries Telnet, Telnet, V5R4
I can connect locally using telnet, but cannot do it from the outside world. Any pointers out there would be appreciated. thanks, Bob
Answer Question
| February 16, 2011 2:50 AM
AS/400 connectivity, iSeries Telnet, Telnet, V5R4
Defining AS/400 Data Areas
I need to access a numeric data area. I do not know at program exection time the library of the data area. This is defined within the program.
Answer Question
| March 9, 2011 1:10 AM
AS/400, AS/400 Data File, AS/400 Library, Data Area
I need to access a numeric data area. I do not know at program exection time the library of the data area. This is defined within the program.
Answer Question
| March 9, 2011 1:10 AM
AS/400, AS/400 Data File, AS/400 Library, Data Area
Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!
We’re always looking for great resources to share with the community, so here’s your chance to share what’s in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you’ll never forget. Don’t have a favorite tech blog? [...]
Answer Question
| August 23, 2011 4:25 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
We’re always looking for great resources to share with the community, so here’s your chance to share what’s in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you’ll never forget. Don’t have a favorite tech blog? [...]
Answer Question
| August 23, 2011 4:25 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Implementing a chat using SQLServer Service Broker – how good an idea it is?
We are designing a chat engine. That’s basically a message queue. When our customers will adopt it, there will be thousands of people chatting. In our company we use SQLServer heavily, and this is an argument for preferring Service Broker over MSMQ. Is Service Broker a good idea? Each chat session will be a new [...]
Answer Question
| February 3, 2011 4:23 PM
Chat applications, SQL 2008, SQL Server, SQL Server 2008
We are designing a chat engine. That’s basically a message queue. When our customers will adopt it, there will be thousands of people chatting. In our company we use SQLServer heavily, and this is an argument for preferring Service Broker over MSMQ. Is Service Broker a good idea? Each chat session will be a new [...]
Answer Question
| February 3, 2011 4:23 PM
Chat applications, SQL 2008, SQL Server, SQL Server 2008
Earn 50 knowledge points by tweeting out our iPad contest!
We’ll give you 50 knowledge points for sending out a tweet about our iPad contest, happening now through February 16th! Spread the word, earn points, and qualify yourself for an iPad or Amazon.com gift card! Contest details at the Community Blog.
Answer Question
| February 3, 2011 3:51 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
We’ll give you 50 knowledge points for sending out a tweet about our iPad contest, happening now through February 16th! Spread the word, earn points, and qualify yourself for an iPad or Amazon.com gift card! Contest details at the Community Blog.
Answer Question
| February 3, 2011 3:51 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
How to get different font sizes to print on an iSeries report
I am trying to change an AS400 print file so that we can print some fields larger than others. The file is printing to a laser printer via client access print emulation session. I have tried to use the FONT keyword but it’s not making a difference. Any ideas how I can acomplish this? Thanks
Answer Question
| March 14, 2012 3:27 PM
AS/400 Print Problems, AS/400 printing, iSeries, iSeries printing
I am trying to change an AS400 print file so that we can print some fields larger than others. The file is printing to a laser printer via client access print emulation session. I have tried to use the FONT keyword but it’s not making a difference. Any ideas how I can acomplish this? Thanks
Answer Question
| March 14, 2012 3:27 PM
AS/400 Print Problems, AS/400 printing, iSeries, iSeries printing
Ping the As/400 servers
Generally we communicate with two as/400 servers by using this Ping command . two servers are Seluas04 an usrias01 When i enter ,” Pin usrias01 ” On seluas04 then Following error Occured . Error–”No response from host within 1 seconds for connection verification 2.” You have any solution for that , Plz repply Bcoz job [...]
Answer Question
| February 7, 2011 9:20 AM
AS/400, AS/400 communication, AS/400 Server
Generally we communicate with two as/400 servers by using this Ping command . two servers are Seluas04 an usrias01 When i enter ,” Pin usrias01 ” On seluas04 then Following error Occured . Error–”No response from host within 1 seconds for connection verification 2.” You have any solution for that , Plz repply Bcoz job [...]
Answer Question
| February 7, 2011 9:20 AM
AS/400, AS/400 communication, AS/400 Server
SQL 9010 Error when using RUNSQLSTM
I have a CL program having the following RUNSQLSTM RUNSQLSTM SRCFILE(AMBDEV/MSRCAMB) SRCMBR(AMBJARRVK) COMMIT(*NONE) AMBJARRVK is a SQL member file in MSRCAMB source file having this SQL statment DELETE FROM GDPF WHERE GDUSID = ‘A365′ AND GDOID = ‘JAR’ I am receiving SQL9010 error when running the CL program… Any hint on where is the [...]
Answer Question
| May 16, 2012 8:03 AM
CL Program, CLPROGRAM, RUNSQLSTM, SQL error messages
I have a CL program having the following RUNSQLSTM RUNSQLSTM SRCFILE(AMBDEV/MSRCAMB) SRCMBR(AMBJARRVK) COMMIT(*NONE) AMBJARRVK is a SQL member file in MSRCAMB source file having this SQL statment DELETE FROM GDPF WHERE GDUSID = ‘A365′ AND GDOID = ‘JAR’ I am receiving SQL9010 error when running the CL program… Any hint on where is the [...]
Answer Question
| May 16, 2012 8:03 AM
CL Program, CLPROGRAM, RUNSQLSTM, SQL error messages
SNDTCPSPLF Problem
Hello all, I ran into an issue with SNDTCPSPLF. Here’s what the command looks like: SNDTCPSPLF RMTSYS(LOCALHOST) PRTQ('QUSRSYS/THISOUTQ') + FILE(&SPOOLFILE) JOB(*) SPLNBR(*LAST) + DESTTYP(*AS400) TRANSFORM(*NO) DLTSPLF(*NO) Where &SPOOLFILE is the name of the spoolfile. The spoolfile gets copied and everything is great. BUT, the user is changing to QTMPLPD. As far as I [...]
Answer Question
| May 31, 2011 7:57 PM
AS/400, AS/400 Spool Files, CLP, iSeries, SNDTCPSPLF
Hello all, I ran into an issue with SNDTCPSPLF. Here’s what the command looks like: SNDTCPSPLF RMTSYS(LOCALHOST) PRTQ('QUSRSYS/THISOUTQ') + FILE(&SPOOLFILE) JOB(*) SPLNBR(*LAST) + DESTTYP(*AS400) TRANSFORM(*NO) DLTSPLF(*NO) Where &SPOOLFILE is the name of the spoolfile. The spoolfile gets copied and everything is great. BUT, the user is changing to QTMPLPD. As far as I [...]
Answer Question
| May 31, 2011 7:57 PM
AS/400, AS/400 Spool Files, CLP, iSeries, SNDTCPSPLF
