Re: Looking DB2 for z/OS discussion list

2011-12-27 Thread Galambos, Robert
The listserv has moved to a new ISP. And as such, if you want to post any questions etc, you must first register on the website, when that is complete you will then be able to post to your heart's content (as long as you follow the 'rules). Email commands are not longer accepted www.idug.org

Re: Data encrypt

2011-11-30 Thread Galambos, Robert
List Well the first item I need to disclose is that I work for a ISV that does offer a Enterprise wide solution to Data Privacy. BUT the thing I want to bring up is not that, BUT a cautionary note. While on the surface JUST encrypting one item/key may seem relatively easy there are far

[AD] Protect Sensitive Data in Test, Protect Your Business: Don't Miss This Webcast - November 10, 2011

2011-11-02 Thread Galambos, Robert
Discover the Latest Advancements in Test Data Privacy Register (http://cl.exct.net/?ju=fe2a1772746c077b701677ls=fdf71379746d0678741772 74m=fefc16747d6607l=fe6b15767564037c7014s=fdfd16707064007a77107776jb =ffcf14t=) Most IT organizations pull test data from their real environment, exposing their

Re: Compuware's Hiperstation.

2011-04-21 Thread Galambos, Robert
A couple of things 1) The best way to go ahead with an instalation/advise that you are looking for is to contact your local Compuware rep. He/she can then put you in contact with some resources that can help (training, advise etc) 2) Also feel free in contacting our support desk. In north

Re: COBOL abend debug question with AbendAid/CICS dump

2011-04-08 Thread Galambos, Robert
Do you have Strobe? If so this can be easier addressed by strobing this program The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it,

Re: S001-03 System Abend Code - FILEAID Batch ABEND

2011-03-07 Thread Galambos, Robert
Please contact your local CPWR support centre to inquiry about this issue. On the web its frontline.compuware.com In north america its 1.800.538.7822 The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the

Re: What is Toronto

2011-02-23 Thread Galambos, Robert
As I head to the bomb shelter in preparation of the replies. Downsview is actually still open, sort of. It is being used by Canadair for final assembly of the Q-400 DASH. So while the 'base' is not open (well there are still military presence there) a runway still exists, and planes fly in

Re: What is Toronto

2011-02-22 Thread Galambos, Robert
Just a note buttonville is still open. Robert Galambos CIPP/C CIPP/IT Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration Certified Information Privacy Professional/Canada Certified Information Privacy Professional/Information

Re: What is Toronto

2011-02-22 Thread Galambos, Robert
as a side note. Person airport is not actually in Toronto but another city called Mississauga which is a city onto itself, has the longest elected mayor I believe anywhere, at least in north America Robert Galambos CIPP/C CIPP/IT Compuware Senior Technical Specialist IBM Certified

Re: What is Toronto

2011-02-22 Thread Galambos, Robert
No sched commercial flights from buttonville Robert Galambos CIPP/C CIPP/IT Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration Certified Information Privacy Professional/Canada Certified Information Privacy

Re: Anyone has experience with File Manager compare?

2010-10-28 Thread Galambos, Robert
Given that another ISV has spoken up, I should do the same. File-AID MVS has a compatible compare function as well, however it is not the only function but one of many. A 'Swiss army' knife of data, if you want but of course I am a little prejudiced ;-). -Original Message- From:

Re: Xpeditor

2010-08-09 Thread Galambos, Robert
For help with any issue of a CPWR, feel free in contacting our Hotline at 1-800-538-7822 in North America or your local Support site outside. If you have any issues in contacting support please let me know off line Robert Galambos CIPP/C CIPP/IT VA3BXG Compuware Senior Technical Specialist

Re: Developers' Use of Prod Data For Testing

2010-06-30 Thread Galambos, Robert
Until now I have refrained from responding BUT I think I need to. First to answer your question, depending on where the data comes from or resides, there may be legal question. Both the EU and Canada to name but two countries, have very 'strong' regulations concerning what a company can do with

Re: UAT Best Practices

2010-06-16 Thread Galambos, Robert
Don't know if what is stated below is something that you are considering, so let me give you my 2 cents. 1) NO 2) NO But seriously here are some of the reasons that will cause you issues Privacy. If you have a separate environment with production data, you MAYBE in jeopardy of contravening

Re: SQL Server replacement

2010-03-25 Thread Galambos, Robert
This is a loaded question. The simply answer is it depends. 1) it depends on what platform you are talking about. Is it z\OS or USS (Linux on the IBM Iron horse) 2) Then it depends on what the DBMS is supporting. Is it a transaction based application where response time is important, is it a

Re: Comparing - ISPF (3.12 and 3.13) with Comparex

2010-03-22 Thread Galambos, Robert
and then destroy it. From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Galambos, Robert Sent: Thursday, March 11, 2010 11:26 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Comparing - ISPF (3.12 and 3.13) with Comparex yet ISV are not allowed to see anything including

Re: Comparing - ISPF (3.12 and 3.13) with Comparex

2010-03-11 Thread Galambos, Robert
1) there is NO one with the last name of redstock in the compuware directory. 2) so it seems that someone who likes a product, is set up for questioning because of such 3) this list is for an open discussion. Good or bad. I normally refrain from posting unless there is a question pertaining to

Re: Comparing - ISPF (3.12 and 3.13) with Comparex

2010-03-11 Thread Galambos, Robert
John Anderson runs a listserv that does not accept ISV input true. BUT john Anderson works for IBM. Sounds a little self serving as IBM is its itself a Software vendor. If you want to question items, that maybe something you may want to also consider Robert Galambos CIPP/C CIPP/IT

Re: Comparing - ISPF (3.12 and 3.13) with Comparex

2010-03-11 Thread Galambos, Robert
yet ISV are not allowed to see anything including expurgated digests. enough said Le contenu de ce courriel s'adresse au destinataire seulement. Il contient de l'information pouvant être confidentielle. Vous ne devez ni le copier ni l'utiliser ni le divulguer à qui que ce soit à moins que

Re: Unable drop or alter DB2 table

2010-03-01 Thread Galambos, Robert
Did you look up the reason code? Robert Galambos CIPP/C CIPP/IT Compuware Senior Technical Specialist IBM Certified Database Associate IBM Certified DB2 9 for z/OS Database Administration Certified Information Privacy Professional/Canada Certified Information Privacy

Re: Compuware FileAid to IBM FileManager Conversion

2010-02-14 Thread Galambos, Robert
up to now I have refrained from entering this debate, as it was something, no matter what I would have said, would be questioned because of the source (me). It is truly up to the organization to way the benefits of any process, weather it is a tool, a new form etc. BUT I have to enter this

Re: Comparing - ISPF (3.12 and 3.13) with Comparex

2010-02-11 Thread Galambos, Robert
OK, just adding my two cents. If you have File-AID MVS you already have a compare tool that does everything comperex does as well as others. And its part of the product. Sorry now back to your regular programming ;-) Robert Galambos CIPP/C CIPP/IT Compuware Senior Technical Specialist

Re: Antwort: compare HFS

2009-12-08 Thread Galambos, Robert
You may not need to get/buy a new utility if you already own File-AID MVS Within the compare function you have the ability to compare HFS files (as well as MVS structures or mix and match) Thought I throw my 2 cents in. Robert Galambos CIPP/C CIPP/IT Compuware Senior Technical

Re: Printing DBCS JES2 command?

2009-11-18 Thread Galambos, Robert
Need to print a report that has double byte chars in it(Thai characters). If it is being spooled to the output que, what is the parameter needed to be specified so it will print properly? Thanks in advance Le contenu de ce courriel s'adresse au destinataire seulement. Il contient de

Re: Where should processing be done was Re: IBM Software Secure Support via USA Citizens

2009-06-22 Thread Galambos, Robert
As a important note. While we are talking about data from going to one country to another for processing/storing etc. One also needs to remember when the data is used develop/test/qa 'outside' the original jurisdiction, data masking consideration is even more important. According to some

Re: IBM Optim question...

2009-05-27 Thread Galambos, Robert
Actually in a fairly/good/large implementation of test data privacy the numbers don't seem to be unreasonable (but there are a number of factors that need to be looked at. (i.e ONLY DB2 data, or MVS/Oracle/VSAM as well, instead of?). Also a number of differnet aspects need to be. An example.

Re: Accessing a big sequential file

2009-05-08 Thread Galambos, Robert
If you have File-AID MVS its as simple as specifying backward processing within the selection criteria option panel and then asking for as many records as you need. Whether the file is 100 or 1 million records long. This can be done on line or batch as well if need be If you want, feel free in

Re: Data masking/data disguise Primer 1) WHY

2009-04-22 Thread Galambos, Robert
First of I want to thank everyone who either has contributed, or at least read this thread. It makes for some eye opening, information gathering, networking opportunities for all. Before I go on, as I stated my intension is a series of threads the first being this WHY. Watch for another either

Data masking/data disguise Primer 2) HOW

2009-04-22 Thread Galambos, Robert
In the spirit of the first thread, I am introducing the second. that is, HOW do we go about protecting/auditing PII (personal identifiable information) The first thing I have to say, don't expect for an average size company to be able within a short period of time to completely

Re: Data masking/data disguise Primer 1) WHY

2009-04-22 Thread Galambos, Robert
See below Robert Galambos CIPP/C CIPP/IT Compuware Senior Technical Specialist IBM Certified Database Associate IBM Certified DB2 9 for z/OS Database Administration Certified Information Privacy Professional/Canada Certified Information Privacy Professional/Information Technology

Data masking/data disguise Primer 1) WHY

2009-04-21 Thread Galambos, Robert
I have noticed a couple of questions in the last couple of months concerning issues along the lines of data disguise/data masking/data obfuscation (a lot of different words for the same issue Protecting PII (personal identifiable information)) from being 'released' My plan, unless there is a

Re: Data masking/data disguise Primer 1) WHY

2009-04-21 Thread Galambos, Robert
, but those are some of MY thoughts! -- ...phsiii Phil Smith III p...@voltage.com Voltage Security, Inc. www.voltage.com (703) 476-4511 (home office) (703) 568-6662 (cell) -Original Message- From: Galambos, Robert robert.galam...@compuware.com Date: Tue, Apr 21, 2009 at 12:06 PM Subject

Re: Data Masking

2009-04-10 Thread Galambos, Robert
While you can make a customized versions for EACH and EVERY type of ACSII/EBCID/VSAM/FLAT file, DB2/IMS/ACESSS etc Database, XML, Excel, etc files (remembering that PII (personnel identifiable information) can be stored in a number of different places), you would also have to maintain all the

Re: Is there a tool to put SMF data into DB/2?

2008-12-18 Thread Galambos, Robert
David Actually this isn't to hard, but will need a couple of different tools in conjunction together 1) you need to parse out the SMF records to a flat file, (Depending on which SMF record and which field you want (or all the fields) that is comma delimited. (you can do this very easily do

Re: searching all members of a pds using wildcards

2008-11-19 Thread Galambos, Robert
Gee there goes another vendor. OPPS that me File-AID MVS Search/update(3.6) can do this, with or without adding Boolean logic to the find (the standard find command) over multiple members of a PDS. No REXX coding needed. Robert Galambos CIPP/C CIPP/IT Compuware Senior Technical

Re: Date Function

2008-10-29 Thread Galambos, Robert
Well Ron it depends on how you want to access the records. Using File-AID MVS batch (with backward processing optionally to make it run quicker) would be the easiest way. There are also a number of Date function within File-AID Data Solutions as well for manipulation if your requirements

Re: last resort - help, I need an SMP/E genius

2008-09-08 Thread Galambos, Robert
toutes les copies du présent message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2008 8:44 AM To: Galambos, Robert Subject: Fw: last resort - help, I need an SMP/E genius Importance: High Hi Robert, firstly, happy Monday to you, and I

Re: Third Party Tool Usage

2008-09-08 Thread Galambos, Robert
Just to time in, since it does concern Compuware. The best source of information concerning this capability is to contact your local Compuware office, where I AM SURE they will be able to help you out on this capability. (this is NOT a separate product but is part of our commitment to provide

Re: FILEAID - PERFORMING SEARCH FUNCTION

2008-06-13 Thread Galambos, Robert
That is incorrect As long as you 'tell' File-AID that you have a panavlet library (and where the link modules are, it will work Please if you have any questions feel free in contacting our hotline at 1-800-538-7822 It is free for all our customers Robert Galambos CIPP/C Compuware

Re: Compare files - with different date fields

2008-06-03 Thread Galambos, Robert
Howard If you have File-AID MVS then the comparison would be very simple, Whether online or Batch Using layouts, or not. You would be able to create the comparison in question. You can indicate which fields/positions you want to compare on (in your case ignoring the date field), as well as an

Re: HIPAA auditing (was:RE: VSAM / COBOL question - redux (fwd))

2008-05-15 Thread Galambos, Robert
All valid questions. While the information captured must be complete (showing the complete session in question from initiation to completion), the storage of the information should be in a 'compressed' form. The reasoning is to try to save on storage space as well. Your question about

Re: HIPAA auditing (was:RE: VSAM / COBOL question - redux (fwd))

2008-05-12 Thread Galambos, Robert
You are correct that this auditing must be done. This Application Auditing must include not just what a RACF log would show - that someone had access to a file, but to show exactly what the user saw. It is one thing to know that someone logged in, accessed a sensitive file and logged out

Re: FW: Workable Mainframe Debuggers

2008-04-18 Thread Galambos, Robert
By the way, I think IBM has the only debugger for IBM C and C++ on z/OS. SORRY to dis-agree with you. Compuware does HAVE a debugger for C (Xped). And it has been out for awhile as well. Robert Galambos CIPP/C Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2

Re: DB2 queries without using MF.

2008-01-23 Thread Galambos, Robert
What I would recommend you do is ask the same question on the DB2-L listserv. You may get some more opinion www.idug.org and go to the listserv tab Robert Galambos CIPP/C Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration

Re: DB2 queries without using MF.

2008-01-23 Thread Galambos, Robert
. From: shai hess [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 23, 2008 12:34 PM To: Galambos, Robert Cc: IBM Mainframe Discussion List Subject: Re: DB2 queries without using MF. HI

ADMIN DB2-L Service Restored

2007-08-11 Thread Galambos, Robert
DB2-L Service Restored We are pleased to announce that the IDUG-sponsored DB2 Listserve (DB2-L) has been restored. A team of very dedicated volunteers has been working literally night and day to restore service following an outage that occurred Friday, July 27. The outage was caused when the

DB2-L listserv

2007-08-10 Thread Galambos, Robert
I wanted to drop a line here to let everyone know that we are still working on bring the DB2-L Listserv back on line. We are a lot closer then we have been, but a number of technical issues have yet to be resolved. There have been volunteers who have been working throughout the night (aside

Re: Db2 Listserv comments

2007-08-08 Thread Galambos, Robert
Hello My name is Robert and I am one of the volunteers who work on the DB2-L listserv. First of all I want to thank all those people who have sent their quires and support during this problem. There has been a number of set back we have experienced during this outage in trying to bring up

Re: Compare two disk files

2007-07-25 Thread Galambos, Robert
Chris If you have File-AID MVS you can do a simple compare, compare two different types of files, compare without most if not all false positives, compare with record layouts, compare with different output files, only those fields that are different, comparisons with tolerances, read

Re: IMS DB2 list

2007-06-20 Thread Galambos, Robert
The YLASSOC listserv was taken over by the IDUG (international DB2 User group) and that listserv address was posted within the thread Robert Galambos Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration [EMAIL PROTECTED]

Re: FILEAID : SEARCH COMMAND

2007-05-08 Thread Galambos, Robert
All you have to do is to go to option 3.6 within File-AID MVS. From there if you go option 'M', specify the PDS library and enter the find/change command like you would normally within SPF and voila. If need be, feel free in contacting the Hotline with any further questions you may have. (I

Re: Will IEBGENER handle a HFS file

2007-05-07 Thread Galambos, Robert
Maybe a little late. But just a note (don't kill the messenger) If you have access to File-AID MVS, Accessing HFS files is exactly the same as accessing files in the MVS catalog. No differences, Capabilities exactly the same (print formatted, audit trails etc.).. This note is also to the

Extract listing of production datasets

2007-04-17 Thread Galambos, Robert
Let me add my two cents in. If you have File-AID MVS it would be very easy to create a Batch job with the following control card statement $$DD01 VTOCDSN UNIT=3390,DSNAME=*P.+ This output can then be manipulated if need be or just listed on a report. If you have any other questions feel

Re: So, OK, no more promotions from me - after this one

2007-01-10 Thread Galambos, Robert
The IDUG DB2 listserv has a good solution to this issue. We require (I am a volunteer) that any promotions, ads, etc, have, as a prefix on the subject line the lateral '[AD]' in this way, those who are interested can still read them and those who do not can delete/filter Just an idea

[OT] Merry xmas Chanukah

2006-12-06 Thread Galambos, Robert
Once again I want to wish you a happy and safe holidays. (this list gets bigger and bigger S) Acholi: Mot ki Yomcwing Botwo Me Mwaka Manyen Adhola: Wafayo Chamo Mbaga Bothi Oro Manyeni Aeka: Keremisi jai be

Re: FILEAID : UNABLE TO EDIT (DELETE PORTIONS) LARGE FILE

2006-11-22 Thread Galambos, Robert
As a side note. When using File-Aid MVS, you have the ability, within the selection criteria options panel to skip and/or select the number of records you want/don't want. (there are a number of additional options you can also use at the same time i.e. stop after certain number of records,

Re: FILEAID : UNABLE TO EDIT (DELETE PORTIONS) LARGE FILE

2006-11-22 Thread Galambos, Robert
Richard No you were not dreaming. File-AID has a number of different ways of supporting VERY VERY large files. Window editing is just one way (as mentioned in this thread previously). There is also Selection criteria, specifying larger temp files (within the parameters section of File-AID)

Re: Mainframe still user surly, File-aid and Endevor aroused my ire.

2006-10-27 Thread Galambos, Robert
Clark See below for answers to your issues. Robert Galambos Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration [EMAIL PROTECTED] Tel: +1 905 886 7000 Toll Free: +1 800 263 7189 Fax: +1 905 886 7023 Quebec: +1

Re: Mainframe still user surly, File-aid and Endevor aroused my ire.

2006-10-27 Thread Galambos, Robert
Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Chase, John Sent: October 27, 2006 11:02 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Mainframe still user surly, File-aid and Endevor aroused my ire. -Original Message- From: IBM Mainframe Discussion List On Behalf Of Galambos

Re: STROBE Report analysis ..

2006-10-19 Thread Galambos, Robert
Have you tried to go to the Compuware's support website frontline.compuware.com ? You can also call our hotline at 1-800-538-7822 to ask your question etc. If you have any questions about this post or having any other issues, please let me know Robert Galambos Compuware Senior Technical

Re: DB2 Help

2006-09-22 Thread Galambos, Robert
You may want to post this message on the DB2-L listserv as well Robert Galambos Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration [EMAIL PROTECTED] Tel: +1 905 886 7000 Toll Free: +1 800 263 7189 Fax: +1 905 886 7023

Re: Production DB2 Problem - some more details ..

2006-09-22 Thread Galambos, Robert
You want to post your question on the DB2-l listserv as well Robert Galambos Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration [EMAIL PROTECTED] Tel: +1 905 886 7000 Toll Free: +1 800 263 7189 Fax: +1 905 886 7023

Catch inefficient code sooner, deliver quality apps faster

2006-07-10 Thread Galambos, Robert
Note the following has been approved to be posted by the List owner Catch inefficient code sooner, deliver quality apps faster Don't let time constraints or code complexity stand in your way of high-performing and highly responsive mainframe applications. Join Compuware's

Re: Search for text in load modules

2006-03-15 Thread Galambos, Robert
Fred Have you tried using File-AID MVS to do the search that you want. If you want, feel free in contacting the support number in AUS to get any of these type of questions answered feel free in either contacting the local HOTLINE number or on frontline.compuware.com which is our internet

Re: Fileaid

2005-10-27 Thread Galambos, Robert
Gerry. On the main panel of File-AID MVS go to utilities, and then to option 6 (SEARCH/UPDATE) the two options are M for a simple FIND/CHANGE over many members of a PDS or U where you can apply Boolean logic (EQ, LT, GE, ETC.) to the change you want Also on Nov 15 Compuware will be having a

Re: Repro VSAM to Tape problem

2005-10-26 Thread Galambos, Robert
Ed Depending on what exactly you want to do, and if you have File-AID MVS. You can probably get The File-AID MVS Batch to do your mentioned steps. In fact chances are that it would run more efficiently as well. Just a thought Robert Galambos Compuware Senior Technical Specialist IBM

Re: Fileaid

2005-08-23 Thread Galambos, Robert
Hi Gerry To answer your question. You should be able to use UPDATE function on the empty file. What this will do is open and then close the file. There should be no need to actually create a record and delete as the only thing you need is an open and close on the file. Just as a side note. If

Join Compuware at SHARE John B. Hynes Convention Center, Boston, MA August 22-24, 2005

2005-08-18 Thread Galambos, Robert
Join Compuware at SHARE John B. Hynes Convention Center, Boston, MA August 22-24, 2005 Visit Compuware Corporation at booth #402 to see our comprehensive DB2 solutions for: ·Interactive analysis, testing and debugging ·File and data management ·Fault

Re: Another, another one bites the dust.

2005-08-03 Thread Galambos, Robert
10 to one the article is based on a PR/news release from one of the companies involved. As in most cases these are veiled self-promotion trying to give impressions that, they hope, will lead others down the same road Robert Galambos Compuware Senior Technical Specialist IBM Certified

Re: How can I convert ER diagram into SQL QUERY

2005-08-01 Thread Galambos, Robert
There is a listserv (DB2-L) listserv that is run by IDUG (international DB2 User Group) that may be of help in answering your questions. (whether OS/Z 390 or LUW versions) You can subscribe at www.idug.org Robert Galambos Compuware Senior Technical Specialist IBM Certified Solutions

Re: JCL Utility for PDS changes

2005-05-24 Thread Galambos, Robert
If you have File-Aid MVS, you should be able to do all using the batch component. If you have question feel free in contacting me, or the Compuware's hotline at 1-800-538-7822 Robert Galambos Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2