midrange.com -- midrange-l mailing list

Re: SQL Casting/Exponential Notation

Luis Rodriguez — 2012-05-17T16:38:45-05:00

John, Michael, The only caveat with the www.easy400.net routines are that converting a table TO XLS can be quite slow (we have an old i5-250, running V5R3) . In fact, I prefer to work with .CSV files either for reading or writing Excel files, only using the Excel-to-PF routines when the data is received in either .XLS or .XLSX format. I have wanted to install and play with iSeries Python for sometime now, but I'm afraid that the free time for that is hard to find. Also, I worry that if I ever go that route ...

Re: How to read the contents of a zip file without unzipping it?

John Yeung — 2012-05-17T16:37:42-05:00

Yes, they are all pretty simple, once installed. Indeed. And some systems are too old to install the others (easily). I have not been able to get 7-Zip set up on our V5R2 system. I'm surprised that ajar was so much quicker than jar. I would have thought ajar was simply a thin wrapper around jar. Another advantage to the "wider variety of Zip files" is that some of those other varieties have much, much tighter compression. The LZMA compression algorithm used by 7-Zip is not as quick as the Deflate algorithm...

Re: IFS save locked objects

Jerry Draper — 2012-05-17T16:35:45-05:00

IFS save locked objects

Jerry Draper — 2012-05-17T16:33:53-05:00

We have objects in these two folders that show up as in use/locked but I really don't think they are in use. What process is holding onto them? Jerry Message . . . . : Object in use. Object is /QIBM/UserData/Eclipse/configuration/org.eclipse.core.runtime/.manager/.tmp3 183446404395653053.instance. Message . . . . : Cannot open object /QIBM/UserData/OS400/UniversalConnection/log/eccAudit0.0.log. Message . . . . : Object in use. Object is /www/geniet/logs/error_log.Q112051600.

Re: How to read the contents of a zip file without unzipping it?

Luis Rodriguez — 2012-05-17T16:23:47-05:00

Scott, You are right, of course. When I wrote about jar/ajar being "easier to use" I was thinking of them, as you say, being already on the system. I'm afraid that sometimes I assume or take for granted things or expressions that I should not... Regarding jar/ajar being slower than other solutions, you have a point there. I don't use them very much on a large number of files, so the performance is not a very pressing issue for our system (an old i5/520, running V5R3). The OP has a large number of files, so ...

RE: best way to limit a job

Musselman, Paul — 2012-05-17T16:23:04-05:00

You could create a separate subsystem, with a fixed memory pool (so you can allocate just so much memory), a single-threaded job queue, and let no other jobs run in that subsystem. Then play games with time slices and run priorities to hamper the job as much as possible! Yes, it 'wastes' that pool of memory (can't be shared), but it might be the only way to throttle the job to less than X%. Of course, if nothing else is running, even a time slice of "1" will end, the system will check for other work to do a...

Re: SQL Casting/Exponential Notation

John Yeung — 2012-05-17T16:20:04-05:00

The tools suggested by Luis are probably pretty good. I have never used them, but I would expect them to be robust. They wrap the HSSF stuff, to provide an easier-to-use interface for typical RPG programmers. If you (or whoever is responsible for such things) are willing to install iSeries Python and xlwt, I have a program which converts physical files to Excel .xls files. No Python knowledge is required, though I would strongly encourage the learning and use of Python anyway. If these options are too scar...

RE: RMTCMD's security?

Monnier, Gary — 2012-05-17T16:15:37-05:00

machine? http://archive.midrange.com/midrange-l. -- John Jones, CISSP -- 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.

Re: OS and hardware upgrade.

Peter Dow — 2012-05-17T16:15:24-05:00

http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/rzamc/rzamcmig ration.htm system. Only the from BPCS restore any a user a stagger -- Regards Evan Harris http://www.auctionitis.co.nz -- 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 mom...

Re: How to read the contents of a zip file without unzipping it?

Scott Klement — 2012-05-17T16:08:25-05:00

Actually, I don't think jar or ajar is any simpler than Info-Zip or 7-Zip. In my post, I listed all of these alternatives, and I think you'll see that none of them is simpler than the other. The advantage to jar/ajar is that it comes with the Java component of the operating system (which most shops already have installed.) The advantage to the PASE solutions (InfoZip/7-Zip) is that they handle a wider variety of Zip files, and they run much, much faster. On my system, listing a Zip file with jar takes near...

Re: RMTCMD's security?

Scott Klement — 2012-05-17T16:03:13-05:00

RE: RMTCMD's security?

Matt Olson — 2012-05-17T15:56:35-05:00

the

RE: RMTCMD's security?

Matt Olson — 2012-05-17T15:52:19-05:00

That's what we did, completely uninstalled that feature. -----Original Message----- From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx] Sent: Thursday, May 17, 2012 1:35 PM To: Midrange Systems Technical Discussion Subject: RE: RMTCMD's security? If they were concerned that you were going to use RMTCMD to access some PC server why didn't they just turn off the remote service on that PC? Rob Berendt

RE: RMTCMD's security?

Matt Olson — 2012-05-17T15:51:47-05:00

So is using an alternative to those commands, apparently private features that would do effectively the same thing, somehow better for any of the auditors, programmers, users, the security\integrity of the requesting system, the security\integrity of the target system? If so, then in what ways? Seems to me that if the target system was insecure prior to the access to those features being denied, then the same exposures remain at the target; being denied those methods still leaves any other possible exploit...

5761WDS Option 31

Laine, Rogers — 2012-05-17T15:39:43-05:00

Can someone tell me if this option must be purchased from IBM or is it part of the 5103 feature? Rogers ************************************************ This E-Mail transmission (and/or the documents accompanying it) may contain information belonging to the sender which is confidential, privileged and/or exempt from disclosure under applicable law. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, you are hereby notified that any ...

RE: RMTCMD's security?

Monnier, Gary — 2012-05-17T15:33:15-05:00

-- 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.

Re: How to read the contents of a zip file without unzipping it?

Luis Rodriguez — 2012-05-17T15:18:15-05:00

Glad to know you are up and running... As Scott stated, jar (or ajar) can be a little slow but, on the other hand, it is really simple to use. As for more on info on Qshell, check out the Infocenter for your particular release. There is a QSHELL manual (in PDF). Also, Google QSHELL and iSeries and I think you can find a lot of references. Best Regards, Luis Rodriguez IBM Certified Systems Expert — eServer i5 iSeries

RE: RMTCMD's security?

rob — 2012-05-17T15:14:32-05:00

Interesting idea Gary. So what you are saying is that let's say you have SystemX, SystemY, SystemZ. And your concern is that a user on SystemX can get to SystemY and use that to initiate nasties on SystemZ. Others, like Scott and I, are arguing that you should be hardening SystemZ to stop attacks on it. Maybe your concern is that perhaps SystemZ was hardened. Perhaps they have a strong exit point on it to only accept remote commands from the IP address associated with SystemY. Your argument is that you shou...

RE: RMTCMD's security?

Monnier, Gary — 2012-05-17T15:10:24-05:00

Re: How to read the contents of a zip file without unzipping it?

fbocch2595 — 2012-05-17T15:09:29-05:00

Hi Folks, we get zip files from a biz partner containing 1000 files. We want o see a listing of these 1000 files without unzipping the zip. Is that ossible? If so, how? Thanks, Frank -- his is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list o post a message email: MIDRANGE-L@xxxxxxxxxxxx o subscribe, unsubscribe, or change list options, isit: http://lists.midrange.com/mailman/listinfo/midrange-l r email: MIDRANGE-L-request@xxxxxxxxxxxx efore posting, please take a moment to review the a...