RE: JDBCR4 Exception in thread "main

Learned something new early today! Does that mean I can go home now?

Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550

-----Original Message-----

From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Danny Rodius
Sent: Wednesday, May 24, 2017 1:15 AM
To: 'RPG programming on the IBM i (AS/400 and iSeries)'
Subject: RE: JDBCR4 Exception in thread "main

Hi,

Not really something in line with the subject but...

When you only want the last level of group ptf's on the system you

could

execute the following:

CHGSRVA PTFGRPLVL(1)

When you install a new set the system will automatically remove the

older

ones.
So no need to manual intervention here.

BR+
Danny


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Kevin Bucknum
Sent: dinsdag 23 mei 2017 16:27
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-
l@xxxxxxxxxxxx>
Subject: RE: JDBCR4 Exception in thread "main

At that TR level he should be able to run this if he has internet

connectivity to

the IBM i.

SELECT substr(PTF_GROUP_CURRENCY,1,26)
as Status, PTF_GROUP_ID as Id ,
substr(PTF_GROUP_TITLE,1,35) as Title,
PTF_GROUP_LEVEL_INSTALLED as Installed ,
PTF_GROUP_LEVEL_AVAILABLE as Available,
PTF_GROUP_LAST_UPDATED_BY_IBM as
LastUpdated FROM
SYSTOOLS.GROUP_PTF_CURRENCY ORDER BY
ptf_group_level_available -
ptf_group_level_installed
DESC,PTF_GROUP_ID desc

I always just go through the workptf list and delete the duplicate

entries that

are at the lower levels. Just leaving the most recent.

Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550

-----Original Message-----

From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Buck Calabro
Sent: Tuesday, May 23, 2017 9:19 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: JDBCR4 Exception in thread "main

On 5/23/2017 8:56 AM, gio.cot wrote:

WRKPTFGRP

SF99572 15 Installed JAVA
SF99572 26 Installed JAVA

Is Ok twice SF99572 ??

Just now I noted that some PTFGRP are duplicated

Yes, this is OK. WRKPTFGRP shows all the groups unless you use

WRKPTFGRP

PTFGRPLVL(*LATEST) This list will probably not look right when it

posts, but it

comes from http://www-
01.ibm.com/support/docview.wss?uid=nas4PSPbyNum

R710 SF99710: Current Cumulative PTF Media Documentation

16320

12/02/2016
R710 SF99709: SF99709 710 Group Hiper 195

05/16/2017

R710 SF99708: SF99708 710 Group Security 70

05/16/2017

R710 SF99707: 710 Technology Refresh 11

11/19/2015

R710 SF99706: SF99706 710 High Availability for IBM i

13

11/15/2016
R710 SF99705: SF99705 710 Hardware and Related PTFs 38
05/11/2017
R710 SF99701: SF99701 710 DB2 for IBM i 41

11/01/2016

R710 SF99657: SF99657 710 DB2 Web Query for i V2.1.1

5

12/29/2016
R710 SF99647: SF99647 710 DB2 Web Query for i V2.1.0

16

12/29/2016
R710 SF99637: 710 DB2 Web Query for IBM i V1.1.2 9
12/12/2013
R710 SF99627: 710 7.1 Electronic Services Group PTF 11
01/21/2014
R710 SF99617: 710 DB2 Web Query for IBM i V1.1.1 6
07/28/2011
R710 SF99572: SF99572 710 Java 27

04/26/2017

R710 SF99381: SF99381 710 WebSphere App Server V8.5 17
12/22/2016
R710 SF99380: SF99380 710 WebSphere App Server V8.0 16
02/16/2017
R710 SF99369: 710 IBM i integration with BladeCenter and

System x

16

12/18/2014
R710 SF99368: SF99368 710 IBM HTTP Server for i 46
04/24/2017
R710 SF99367: SF99367 710 TCP/IP PTF 10

06/25/2016

R710 SF99366: SF99366 710 Print PTFs 13

04/12/2017

R710 SF99364: 710 WebSphere App Server V6.1 9
09/09/2013
R710 SF99363: SF99363 710 WebSphere App Server V7.0 20
04/21/2017
R710 SF99362: SF99362 710 Backup Recovery Solutions 66
05/21/2017
R710 SF99359: SF99359 710 WebSphere MQ for i5/OS -

v7.0.1/v7.1.0/v8.0.0

27 02/01/2017
R710 SF99335: SF99335 710 DB2 Web Query for i V2.2.0

3

04/24/2017
R710 SF99250: SF99250 710 Content Manager OnDemand for i -

5770-RD1

7.1
6 04/26/2017
R710 SF99145: SF99145 710 Performance Tools 12
03/29/2017
R710 SF99123: SF99123 710 IBM Open Source Solutions for i

3

01/19/2017

In particular, your cume looks OK, and you are at TR11 which is the

last TR for

7.1, but you need to check Java, DB2, and HTTP and bring them up to

date.

Java is only one group behind, but I would still bring it current.

I never saw a problem like you had when I was on 7.1. If it happens

again I

would call IBM for software support.

--
--buck

Try wiki.midrange.com!

--
This is the RPG programming on the IBM i (AS/400 and iSeries)

(RPG400-L)

mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To

subscribe,

unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take

a

moment to review the archives at

http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our

affiliate

link: http://amzn.to/2dEadiD

--
This is the RPG programming on the IBM i (AS/400 and iSeries)

(RPG400-L)

mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To

subscribe,

unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
http://amzn.to/2dEadiD

--
This is the RPG programming on the IBM i (AS/400 and iSeries)

(RPG400-L)

mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To

subscribe,

unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD