Deleting PJ QZDASOINIT jobs after inactivity
We have a lot of PJ QZDASOINIT jobs in QUSRWRK. Many are from the same ‘user’ and Server IP address. Is there a way to delete these jobs after a period of odbc/jdbc inactivity – or should we keep them?
Answer Question
| September 27, 2010 9:08 PM
AS/400, AS/400 jobs, QUSRWRK, QZDASOINIT
We have a lot of PJ QZDASOINIT jobs in QUSRWRK. Many are from the same ‘user’ and Server IP address. Is there a way to delete these jobs after a period of odbc/jdbc inactivity – or should we keep them?
Answer Question
| September 27, 2010 9:08 PM
AS/400, AS/400 jobs, QUSRWRK, QZDASOINIT
AS/400: Ending call stack up to a particular program
Hello All, I have a question. Here is the scenario: A job calls PGM A and it in turn calls PGM B. Note: Both A and B are ILE programs and created with activation group, *CALLER. PGM A ******** /Free ………………. ………………. CallP PGM B (Parm1: Parm2); Var1 = Parm2; ………………. ………………. /End-Free ********* Is [...]
Answer Question
| July 21, 2009 3:19 PM
AS/400 Call stack, AS/400 jobs
Hello All, I have a question. Here is the scenario: A job calls PGM A and it in turn calls PGM B. Note: Both A and B are ILE programs and created with activation group, *CALLER. PGM A ******** /Free ………………. ………………. CallP PGM B (Parm1: Parm2); Var1 = Parm2; ………………. ………………. /End-Free ********* Is [...]
Answer Question
| July 21, 2009 3:19 PM
AS/400 Call stack, AS/400 jobs
Many jobs created with iSeries Nav collects inventory
Recently I installed iSeries Access service pak SI32972 on my PC. This includes updates to Navigator. Since the install, every time we collect inventory (fixes, users, etc) about 400 jobs are added to our iSeries. These jobs remain until we ENDTCPSVR *MGTC. These jobs also consume disk space which is released only when we ENDTCPSVR [...]
Answer Question
| July 13, 2009 5:05 PM
AS/400 jobs, AS/400 prestart jobs, iSeries Access, iSeries Navigator
Recently I installed iSeries Access service pak SI32972 on my PC. This includes updates to Navigator. Since the install, every time we collect inventory (fixes, users, etc) about 400 jobs are added to our iSeries. These jobs remain until we ENDTCPSVR *MGTC. These jobs also consume disk space which is released only when we ENDTCPSVR [...]
Answer Question
| July 13, 2009 5:05 PM
AS/400 jobs, AS/400 prestart jobs, iSeries Access, iSeries Navigator
QTEMP batch job vs QTEMP interactive job
Hi all, Can some body please explain me the difference between Qtemp of a batch job to the qtemp of an interactive job? Thanks
Answer Question
| June 10, 2009 9:39 AM
AS/400 administration, AS/400 jobs, QTEMP
Hi all, Can some body please explain me the difference between Qtemp of a batch job to the qtemp of an interactive job? Thanks
Answer Question
| June 10, 2009 9:39 AM
AS/400 administration, AS/400 jobs, QTEMP
Submit JOB
How to submit a JOB in AS/400 i need a step by step process
Answer Question
| May 28, 2009 1:38 PM
AS/400 Job Queue, AS/400 job scheduler, AS/400 jobs
How to submit a JOB in AS/400 i need a step by step process
Answer Question
| May 28, 2009 1:38 PM
AS/400 Job Queue, AS/400 job scheduler, AS/400 jobs
Having a job queue for multiple Subsystems
Hello Can i have multiple subsystems which uses the same job queue. WIll this have some effect on jobs normal processing. Thanks
Answer Question
| August 6, 2009 7:54 PM
AS/400, AS/400 Job Queue, AS/400 jobs
Hello Can i have multiple subsystems which uses the same job queue. WIll this have some effect on jobs normal processing. Thanks
Answer Question
| August 6, 2009 7:54 PM
AS/400, AS/400 Job Queue, AS/400 jobs
Import AS/400 files into SQL server
Hi I would like to know how to create a job to transfer all the files (data) from AS/400 to SQL server 2005 (keep as backup)
Answer Question
| May 1, 2009 6:31 PM
AS/400 backup, AS/400 jobs, SQL Server 2005
Hi I would like to know how to create a job to transfer all the files (data) from AS/400 to SQL server 2005 (keep as backup)
Answer Question
| May 1, 2009 6:31 PM
AS/400 backup, AS/400 jobs, SQL Server 2005
AS400 Disk space
AS400 Disk space I’ve just inherited the responsibility for a couple of old AS400 (model 510, OS V4R5) which are out of support and although I spent many years supporting AS400 I’ve not touched them in the last 6 years and I have a little problem with them. The problem is the system ASP is [...]
Answer Question
| July 28, 2009 12:31 PM
AS/400, AS/400 jobs, AS/400 storage, OS/400, PRTDSKINF, RCLSTG
AS400 Disk space I’ve just inherited the responsibility for a couple of old AS400 (model 510, OS V4R5) which are out of support and although I spent many years supporting AS400 I’ve not touched them in the last 6 years and I have a little problem with them. The problem is the system ASP is [...]
Answer Question
| July 28, 2009 12:31 PM
AS/400, AS/400 jobs, AS/400 storage, OS/400, PRTDSKINF, RCLSTG
New Web Service Project
Hi, Currently an iSeries job runs every 10 minutes where, at the back end, a file is read (more than 400 fields), a pipe delimited file is created and FTP’d to an outside location. Volume would normally be low but intermittently there could be a spike. I need to replace the FTP process with a [...]
Answer Question
| March 6, 2009 10:05 PM
AS/400 development, AS/400 jobs, FTP, iSeries, Java, V5R4, Web development, Web Services Standards, WebSphere, XML
Hi, Currently an iSeries job runs every 10 minutes where, at the back end, a file is read (more than 400 fields), a pipe delimited file is created and FTP’d to an outside location. Volume would normally be low but intermittently there could be a spike. I need to replace the FTP process with a [...]
Answer Question
| March 6, 2009 10:05 PM
AS/400 development, AS/400 jobs, FTP, iSeries, Java, V5R4, Web development, Web Services Standards, WebSphere, XML
Check if a specific job for a user is active.d
I found CHKACTJOB which will tell me if a generic job for a user is active. How can I find out if a specific job number for a user is active?
Answer Question
| March 4, 2009 3:16 PM
AS/400 command keys, AS/400 jobs, CHKACTJOB
I found CHKACTJOB which will tell me if a generic job for a user is active. How can I find out if a specific job number for a user is active?
Answer Question
| March 4, 2009 3:16 PM
AS/400 command keys, AS/400 jobs, CHKACTJOB
How to auto schedule a job/cmd in Webshpere.
Hi – I’m no Webphere guru and have been preented the task to set in the job scheduler a job to run a Websphere report/job. Best I can come up with so far is executing in Shell a command to the similar: STRQSH CMD(‘/QIBM/USERDATA/JAVA/SERVER/MATRIXREPORT.CMD’) Can some confirm or deny the syntax looks correct here…??? First [...]
Answer Question
| March 2, 2009 4:45 PM
AS/400 command keys, AS/400 jobs, Shell commands, WebSphere
Hi – I’m no Webphere guru and have been preented the task to set in the job scheduler a job to run a Websphere report/job. Best I can come up with so far is executing in Shell a command to the similar: STRQSH CMD(‘/QIBM/USERDATA/JAVA/SERVER/MATRIXREPORT.CMD’) Can some confirm or deny the syntax looks correct here…??? First [...]
Answer Question
| March 2, 2009 4:45 PM
AS/400 command keys, AS/400 jobs, Shell commands, WebSphere
joblog as400 printing
I’m running a job that could write many joblogs. What I want: if there are any kind of errors (even those answered with an Ignore) the joblog will print, else there is no joblog printed. I can get prints on a hard cancel of a clp but not if answered with an ignore.
Answer Question
| February 5, 2009 2:22 PM
AS/400 jobs, AS/400 printing, CLP
I’m running a job that could write many joblogs. What I want: if there are any kind of errors (even those answered with an Ignore) the joblog will print, else there is no joblog printed. I can get prints on a hard cancel of a clp but not if answered with an ignore.
Answer Question
| February 5, 2009 2:22 PM
AS/400 jobs, AS/400 printing, CLP
as400 jobs
can we change a batch job to interactive or vice versa? If yes how? thanks
Answer Question
| May 10, 2009 8:23 PM
AS/400 batch jobs, AS/400 Interactive Jobs, AS/400 jobs
can we change a batch job to interactive or vice versa? If yes how? thanks
Answer Question
| May 10, 2009 8:23 PM
AS/400 batch jobs, AS/400 Interactive Jobs, AS/400 jobs
AS/400
How can I hold all the print jobs in the as/400 for just one user, then have the same user to release all her jos whenever she wants to print. thanks
Answer Question
| January 26, 2009 8:26 PM
AS/400 jobs, AS/400 printing, AS400 printing jobs
How can I hold all the print jobs in the as/400 for just one user, then have the same user to release all her jos whenever she wants to print. thanks
Answer Question
| January 26, 2009 8:26 PM
AS/400 jobs, AS/400 printing, AS400 printing jobs
Is AS/400 journal time JOTIME accurate?
I have three jobs that ran today and wrote records to the same file. JOTIME showed all 9 writes and 1 update @ 12:37:25 for job1. Job 2 with 5 writes at 2:38:00. Job 3 with 4 writes and an update all at 12:38:27. The program logic says that each job should have deleted the [...]
Answer Question
| March 6, 2009 9:06 PM
AS/400 jobs, AS/400 Journal Time, AS/400 journaling, JOTIME
I have three jobs that ran today and wrote records to the same file. JOTIME showed all 9 writes and 1 update @ 12:37:25 for job1. Job 2 with 5 writes at 2:38:00. Job 3 with 4 writes and an update all at 12:38:27. The program logic says that each job should have deleted the [...]
Answer Question
| March 6, 2009 9:06 PM
AS/400 jobs, AS/400 Journal Time, AS/400 journaling, JOTIME
jobq entries
Is there a limit to the number of jobs set to run in a jobq? I have a program that reads a file of LT 1500 rcds and there is the potential that all of those records could be submitted to run in batch. Thinking about the future, I suppose there could be close to [...]
Answer Question
| January 20, 2009 5:44 PM
AS/400 jobs, JOBQ, JOBQ Job Limit
Is there a limit to the number of jobs set to run in a jobq? I have a program that reads a file of LT 1500 rcds and there is the potential that all of those records could be submitted to run in batch. Thinking about the future, I suppose there could be close to [...]
Answer Question
| January 20, 2009 5:44 PM
AS/400 jobs, JOBQ, JOBQ Job Limit
AS/400 idle notice
Does anyone know of a way to have the system call a program when a user’s screen is idle for a certain period of time?
Answer Question
| January 8, 2009 9:51 PM
AS/400 Idle Notices, AS/400 jobs, AS/400 journaling
Does anyone know of a way to have the system call a program when a user’s screen is idle for a certain period of time?
Answer Question
| January 8, 2009 9:51 PM
AS/400 Idle Notices, AS/400 jobs, AS/400 journaling
As/400 Job number ..Two part question
Hi all, We are in the process of implementing online paystubs for employees to view. Here are the steps that I am trying to automate from the IT side of the house. 1) Clrpfm 2) cpysplf 3) cpytopcd So far..number to is the issue due to not knowing what the job number will be in [...]
Answer Question
| December 23, 2008 1:30 PM
AS/400 jobs, CLRP, Command line, CPYSPLF, CPYTOPCD, Sungard Software
Hi all, We are in the process of implementing online paystubs for employees to view. Here are the steps that I am trying to automate from the IT side of the house. 1) Clrpfm 2) cpysplf 3) cpytopcd So far..number to is the issue due to not knowing what the job number will be in [...]
Answer Question
| December 23, 2008 1:30 PM
AS/400 jobs, CLRP, Command line, CPYSPLF, CPYTOPCD, Sungard Software
Setting run priority on prestart jobs
We have several applications that query the iSeries through ODBC, so they all use the prestart job QZDAINIT. Is there a way to change the run priority on these jobs so that one application’s queries can have a higher priority than another application’s queries? Since each application’s queries always use the same user ID, can [...]
Answer Question
| January 6, 2009 3:07 PM
AS/400 Job Prioritization, AS/400 jobs, AS/400 performance, ODBC, QZDAINIT
We have several applications that query the iSeries through ODBC, so they all use the prestart job QZDAINIT. Is there a way to change the run priority on these jobs so that one application’s queries can have a higher priority than another application’s queries? Since each application’s queries always use the same user ID, can [...]
Answer Question
| January 6, 2009 3:07 PM
AS/400 Job Prioritization, AS/400 jobs, AS/400 performance, ODBC, QZDAINIT
AS/400 iSeries Submitted Job/Batch Record Lock issue
I have looked at the other record lock questions/answers on this board but have been unable to find an answer to this problem. I am trying to capture a record lock error in a submitted program. The program is coded to capture the File Status as shown below. I have tested this same record locking [...]
Answer Question
| November 28, 2008 2:50 PM
AS/400 jobs, Record lock
I have looked at the other record lock questions/answers on this board but have been unable to find an answer to this problem. I am trying to capture a record lock error in a submitted program. The program is coded to capture the File Status as shown below. I have tested this same record locking [...]
Answer Question
| November 28, 2008 2:50 PM
AS/400 jobs, Record lock
