Re: Starting the servers for SQL access?

[Evan Harris <auctionitis@xxxxxxxxx>]

Run a CWBPING command from a workstation with client access installed
- it might provide more information about servers and ports required.

On Wed, Mar 23, 2011 at 11:19 AM, James Lampert
<jamesl@xxxxxxxxxxxxxxxxx> wrote:
> Craig Pelkie wrote:
> > Would that be STRHOSTSVR?
> >
> > *DATABASE
> >
> > Probably also *CENTRAL, *SIGNON, might be easiest to just use *ALL
>
> Thanks. STRHOSTSVR *DATABASE produces this joblog:
>
> 3 > STRHOSTSVR SERVER(*DATABASE)
>     Host server daemon jobs unable to communicate using IPX.
>     Start Prestart Jobs command is not allowed now.
>     Start Prestart Jobs command is not allowed now.
>     Start Prestart Jobs command is not allowed now.
>     Routing entry sequence number 600 already exists.
>     Compare value conflicts with routing entry 600.
>     Host server daemon job already active.
>
>
> The first "Start Prestart . . . " message produces this:
> Cause . . . . . :   The Start Prestart Jobs (STRPJ) command is not valid
> at
>   this time for reason 1.  See reason 1 shown below:
>
>     1 - The prestart jobs for program QZDASOINIT in library QIWS in
> subsystem
>   QSERVER are already active.
>
>
>
> We currently have these port restrictions in place:
>         --Port Range---                  User
> Opt     Lower     Upper     Protocol     Profile
>                   *ONLY
>           137     *ONLY       *TCP       QUSER
>           137       138       *UDP       QUSER
>           139     *ONLY       *TCP       QUSER
>           448       449       *TCP       QSYS
>           500     *ONLY       *TCP       QSYS
>           500     *ONLY       *UDP       QSYS
>          8470      8479       *TCP       QSYS
>          9470      9476       *TCP       QSYS
>
> --
> JHHL