RE: iSeries running Oracle Goldengate

That's because they are running in PACE. (nee AIX inside IBM i)

I think the solution is a simple one.

Create a subsystem (remember to use appropriate memory shared pools in this
example I use Shared Pool 1)
Add a workstation entry for *ENTER to the subsystem
Create a job queue with the same name as the subsystem
Add the job queue entry to the subsystem
Add a routing entry to the subsystem with *ANY as the routing data

Now sign on and TFRJOB to that subsystem.
Go into the PACE terminal and start your job. It should run right there.

SO:

CRTSBSD SBSD(ORACLE) POOLS((1 *BASE) (2 *SHRPOOL1))
CRTJOBQ JOBQ(ORACLE)
ADDJOBQE SBSD(ORACLE) JOBQ(ORACLE) MAXACT(*NOMAX)
ADDWSE SBSD(ORACLE) WRKSTNTYPE(*ALL) AT(*ENTER)
ADDRTGE SBSD(ORACLE) SEQNBR(9999) CMPVAL(*ANY) PGM(QCMD) POOLID(2)

STRSBS ORACLE

Sign on to QINTER

TFRJOB ORACLE
Go into QP2TERM and start your job.






--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Kevin
Kimsey
Sent: Friday, July 01, 2016 8:39 AM
To: Midrange Systems Technical Discussion
Subject: RE: iSeries running Oracle Goldengate

The Goldengate jobs have no job log - which is something I have never seen
in my 20 some years working on iSeries.


Display Job Log

System: FCDEV

Job . . : MGR User . . : KK80623 Number . . . : 987710





No job log information.






-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Charles Wilt
Sent: Friday, July 01, 2016 8:33 AM
To: Midrange Systems Technical Discussion
Subject: Re: iSeries running Oracle Goldengate

Take a look at the job logs...

At the beginning is there a line:
Job 542285/OLSOWN/ORDERPROC submitted.

Doing an F1 on that line would should some more info:
Message . . . . : Job 542285/OLSOWN/ORDERPROC submitted.
Cause . . . . . : Job 542285/OLSOWN/ORDERPROC submitted to job queue
OLSSYSTEM in OLSMLPRG from job 542280/WILTA/ENDOFDAY. Job
542285/OLSOWN/ORDERPROC was started using the Submit Job (SBMJOB) command
with the following job attributes: JOBPTY(5) OUTPTY(5) PRTTXT() <snip>



On Fri, Jul 1, 2016 at 9:17 AM, Kevin Kimsey <KimseyKevin@xxxxxxx> wrote:

In QP2TERM - I start the Goldengate application. From there, I can
start processes by issuing GG commands - Start Manager, Start Replicat
or Start Extract.


/QOpenSys/usr/bin/-sh



GGSCI (FCDEV.FMHI.COM) 1>
> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT ABENDED EXT2 00:00:00 18:45:50
EXTRACT ABENDED EXT3 00:00:00 1466:08:15
REPLICAT RUNNING REP1 00:00:00 00:00:06


GGSCI (FCDEV.FMHI.COM) 2>

===>



-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Jim Oberholtzer
Sent: Friday, July 01, 2016 8:06 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: iSeries running Oracle Goldengate

Kevin:

Can you give me a clue as to how the jobs get started in the first place?

Most likely we will have to create a job description for the job that
starts this one that has routing data set up to cause the jobs to move
to a new
subsystem. /OR/ It might be easier to create a subsystem that you can
run
these jobs in, sign on to a workstation, transfer into that subsystem
and start them there.

We won't know until we see what starts the jobs in the first place.

--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Kevin Kimsey
Sent: Friday, July 01, 2016 7:31 AM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: iSeries running Oracle Goldengate

Hello,

I am running :
Oracle GoldenGate Command Interpreter for DB2 for i Version 12.2.0.1.2
OGGCORE_12.2.0.1.0_PLATFORMS_160310.1305
IBM i, ppc, 64bit (optimized), IBM DB2 for i on Mar 10 2016 23:37:00
Operating system character set identified as ISO-8859-1.

On iSeries at V7R1M0 in QP2TERM. It works very well to replicate data
between our iSeries and Oracle platforms, but the issue I am having is
the jobs that Goldengate runs get submitted to the QINTER subsystem.
How can I make them submit to QBATCH or QUSRWRK subsystems?


Subsystem/Job User Type CPU % Function Status
QINTER QSYS SBS .0 DEQW
MGR AUTBRK BCI .0 PGM-mgr SELW
OGG AUTBRK BCI .0 PGM-server SELW


Kevin Kimsey
Email: kimseykevin@xxxxxxx<mailto:kimseykevin@xxxxxxx>

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.