Hi Bill,
Do a wrkjvmjob and you'll see exactly what uses Java 6, 7 and 8. Just put a 9 on each entry.
The stuff explicitly defined to run on Java 6 with a java_home entry will not run on Java 7 and 8 unless you change that entry to point at the JRE for 7 or 8.
If not explicitly defined then it'll use the default available on the system. If no default (Java 6 on 7.1) then it'll use either 7 or 8.
We do a lot of 7.1-7.3 upgrades...best to test by moving those apps to Java 7/8 before removing the 6 licpgm. It's the safest way to do it.
Steve Pitcher
iTech Solutions
Office: (203) 744-7854 Ext. 176
Mobile: (902) 301-0810
http://www.itechsol.com
http://www.iInTheCloud.com
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of broehmer@xxxxxxxxxxxxxxx
Sent: Friday, May 4, 2018 6:38 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Java - 6
Have a question relating to Java on the system.
I'm at 7.1 and my (boss) wants to go ahead and remove Java 6 on our development box and see what happens.
We've got 7 & 8 on it and while I realize that when we move to 7.3 (next month) that won't matter but his question is what's going to happen to our system now?
How much "stuff" relies on 6 and why can't we just move to 7 or 8?
Bill Roehmer
Senior Pgmr/Analyst
The C.D. Hartnett Company
817 594-3813 ext. 1631
"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments
accompanying it) contain confidential information belonging to the sender.
The information is intended only for the use of the intended recipient.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution or the taking of any action in reliance
on the contents of the information is strictly prohibited. Any
unauthorized interception of this transmission is illegal under the law.
If you have received this transmission in error, please promptly notify
the sender by reply e-mail, and then destroy all copies of the
transmission."
From: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 05/04/2018 01:06 PM
Subject: RE: Better SQL performance than SUBSTRING
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
That doesn't seem to work for me. The statement ran, but no object was
created.
Here's my statement:
create index MY_TABLE_SUBSTRING on table MY_TABLE
(SUBSTRING(MY_COLUMN,5,6))
Here's the message iACS gave me on the create:
SQL State: 01505
Vendor Code: 143
Message: [SQL0143] Statement CREATE INDEX AUXILIARY TABLE ignored. Cause .
. . . . : Statement CREATE INDEX AUXILIARY TABLE is not supported by DB2
for IBM i. It has been ignored. Recovery . . . : No action is
required.
Statement ran successfully, with warnings (6 ms)
IBMi 7.3, PTF's current as-of 07 Apr 18
iACS 1.1.7.3
-----Original Message-----
From: Steve Needles [mailto:Stephen.Needles@xxxxxxxxxxx]
Sent: Friday, May 04, 2018 10:09 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Better SQL performance than SUBSTRING
Yes...you can create an index using a substring:
CREATE INDEX Table_Index
ON Table
(substr(Column,case when length(trim(Column))-7 <= 0
then 1
else length(trim(Column))-6 end
, 7));
Generate a key using the last characters in the string no matter the total
length of the string
Steve Needles
midrange.com
