z/OS 1.4 on Z9?
Will z/OS 1.4 run on a Z9 under VM if it ran on a Z990 under VM…it is a vanilla OS. I KNOW it is out of support!!!

Answer Question   |  November 1, 2012  5:57 PM
z/OS

A problem when BDAM files with key are copied by DFSMSdss.
I have a problem with my BDAM files with key when the files are copied using DFSMSdss of z/OS. If the files are copied using physical processing, everything is OK. If the files are copied using logical processing, reading existing records is OK, but writing a new record into the copied files fails with BDAM [...]

Answer Question   |  October 8, 2012  9:21 AM
DFSM, z/OS

SYSRES cloning Z/OS
Hi All, I am trying to understand about cloning the sysres volume of our z/os 1.12. Our environment is basically a Z9 machine with 1 cpc with only two LPAR images created with no coupling facility(Monoplex). To clone a sysres volume we are required to peform a indirect cataloging and clone your source sysres to [...]

Answer Question   |  April 4, 2012  4:24 AM
SYSRES, z/OS

Expired or deleted RACF accounts that are still active in DB2
Hello, I have a question related to ‘expired or deleted RACF accounts that are still active in DB2′. In our shop, with z/OS as the operating system and RACF as a security tool. While DB2 native security is used to manage access for each of the DB2 objects such as database, table, view, or storage [...]

Answer Question   |  March 14, 2012  10:10 PM
DB2, RACF, z/OS

UACC vs Generic Userid
As a long time RACF guy, I have believed that although it would be a rare scenario to exploit this, Universal Access (UACC) will allow access to an ‘MVS user’ that is not necessarily RACF defined and hasn’t been authenticated through RACF, yet Generic Userid (*) equates to ‘any RACF defined user’, which requires the [...]

Answer Question   |  October 14, 2011  6:20 PM
Generic User UACC, RACF, z/OS

Capture Select Statistics report
I want to run a batch job to create a Select Statistics report and capture the report in a dataset. What commands do I use?

Answer Question   |  April 11, 2011  2:01 AM
AS/400 batch jobs, Batch jobs, NDM, z/OS

In z/OS, can you write a message to another job’s job log?
I’ve got several situations where I’d like a program (e.g. a batch program) to be able to write a message in another job’s job log (e.g. to a CICS region saying “I’ve just set application ABC into overnight mode” or some such). I don’t recall seeing this feature anywhere and have been through the Assembler [...]

Answer Question   |  December 31, 2010  2:37 AM
Display Job Log, Joblog, z/OS, z/OS configuration

Qmf for Windows 8.1 fp18 – date datatype from db2 z/os 8 format error in excel 2003
When I import a DB2 z/OS query result  containing date or date(timestamp) columns from QMF for WINDOWS in EXCEL 2003 using the Add-in the cells cannot be formatted. In the same column the date are displayed sometimes as dd/mm/yyyy, sometimes as nnnnn or in the previously defined format (example dd-month ) if exists. The first [...]

Answer Question   |  December 20, 2010  10:56 AM
DB2, Excel 2003, Excel 2003 formulas, QMF, QMF V8, Windows XP SP2, z/OS

Advice needed on “DB2 DBA for Z/OS career”
Hello there, I am a mainframe professional with over 6 years of experience. I worked mainly in IDMS database throughout my career. However, i am interested to learn database administration in DB2. I did clear initial DB2certification long back. 1>  To do DB2 DBA, how difficult is it for me as i am from IDMS back [...]

Answer Question   |  October 28, 2011  4:37 PM
Database administration, DB2, DB2 DBA for Z/OS, z/OS

Installing LDAP on z/os 1.9
I need to install ldap on zos 1.9 but not sure where to start..this is for replication

Answer Question   |  September 10, 2010  2:59 PM
LDAP, z/OS, z/OS 1.9, z/OS configuration

How can I run a SAS program in mainframe that calls Oracle in Unix
Hi, I need to run my SAS program in z/OS which call Oracle in Unix to retreive data from Oracle table. I tried this SAS program in PC SAS without any problem. How do I connect to Oracle in my SAS prgram in z/OS? Need help, please    

Answer Question   |  August 13, 2010  7:12 PM
Mainframe, Oracle, Oracle Table, SAS, SAS programming, Unix, z/OS

DB2 for Z/OS and DB2 for LINUX / WINDOWS/ AS400
I have around 5 years of IT experience in Mainframe and Midrange operations. As I’m more intersted in database administration, recently I did IBM DB2 9 Fundamentals certification and also IBM Mainframe application development course ( JCL,VSAM,COBOL,DB2,CICS) but it was 5 years back. I want to go for professional certification in DB2 for Z/OS as [...]

Answer Question   |  September 27, 2011  10:52 PM
AS/400, AS/400 DB2, DB2, IT career planning, z/OS

How to known the z/OS version in a batch program
Hi, I want known the z/OS version in the program. For instance, how to does it  retrive the command “D IPLINFO”, in a batch program? Thanks, Evandro

Answer Question   |  June 30, 2010  8:16 PM
AS/400 batch jobs, Batch jobs, z/OS

How to recover a PDS member
z/os mainframe. A member from a partitioned dataset has been accidentally deleted . No backup. I guess the deletion is done logically and not phisically untill next compress (a king of flag aside) . So, there must be a command that  let  recover the member (unflag it). Coud anyone give some help? Thanks

Answer Question   |  April 30, 2012  3:44 PM
Dataset, Mainframe Datasets, Partitioned Data Sets (PDS), PDS, z/OS

Mainframe – Someone moving my DB2 Object to READ ONLY
How to know who is or which application moving my TS to READ ONLY in a z/OS environment?  

Answer Question   |  February 3, 2010  2:39 PM
DB2, iSeries objects, z/OS

can anyone please help me why by billing job is failing with SR04 ?
can anyone please help me why by billing job is failing with SR04 ?

Answer Question   |  January 22, 2010  10:01 AM
Billing Support Systems, z/OS, z/OS configuration

How to sort a variable length file, with multiple record types
12345     101xxxxxxxx 12345     201xxxxxxxx1 12345     201xxxxxxxx2 12346     104xxxxxxxx 12346     204xxxxxxxx1 12347     101xxxxxxxx 12347     201xxxxxxxx1   Above is an example of a file I am trying to sort.  I want to sort by the 2nd and 3rd characters, of the right table (01, 04, etc).  The first character in the right table is a record type (1 [...]

Answer Question   |  June 8, 2012  6:35 PM
z/OS

DECFLOAT – Internal Format
Hello, How to translate an internal DECFLOAT value into a visual format? DB2 Administration Guide: “Convert and return a DECFLOAT representation of a number or string representation of a number”, (Appendix A. Writing exit routines). There is an example there: Internal Format              DFP Format                String Representation D8F77D00000000000C    222C000000001E80     +7.500     They do not explain, how to [...]

Answer Question   |  February 1, 2010  2:47 PM
DB2, DB2 9, DB2 administration, DECFLOAT, z/OS

Pause/Wait + JCL z/0s
Is there a way to pause ZOS between each step of a job? If we had JES3 installed, I would use //**PAUSE, but we don’t. My job has six commands I want to automate. F PCICST01, CEMT S TE(????)OUT, and 5 more, where ???? is the LU code needed. If I understand ZOS, it may [...]

Answer Question   |  October 13, 2009  2:44 PM
JCL, z/OS

How To create an CSV file in Mainframe (from Object star database)?
I have to create some extract from Object star tables, in CSV format.Please let me know if any utility or programe can be used.

Answer Question   |  April 19, 2010  6:18 AM
CSV file format, z/OS