• VSAM versus DB2 in CPU consumption

    Is it possible estimate how much more CPU is consumed by DB2 commands in relation to VSAM KSDS when access a row, through an index scan, in a organized DB2 table against a record reading from an organized VSAM KSDS file through the primary index? How much is it in percentage? Thank you very much in...

    Abelmart30 pointsBadges:
  • 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...

    Abeshaman5 pointsBadges:
  • 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...

    PM0075 pointsBadges:
  • 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',...

    ThePriest5 pointsBadges:
  • 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...

    Sarada1115 pointsBadges:
  • FTP from z/OS PDS to server (how to add on .txt extension)

    I'm relatively new to FTP. Have written a JCL which will copy all members of a local PDS to a remote server. This process is somewhat successful, however all the same named filenames on the remote server reflect only the PDS member name (without any extension). Have used the LCD command to map to...

    Herb5 pointsBadges:
  • Tables in DB2 z/OS

    In which dataset will I be able to find the default tables of DB2 V9 in Z OS

    KarishmaKapoor20 pointsBadges:
  • 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...

    Jamesp3315 pointsBadges:
  • CICS commands

    Hi, I am using PCOM for accessing Z OS. I am new to Mainframes. I want to fire this command. CEDA DEF PROG(PROG1) GROUP(GRP1) LANG(COBOL). When i googled I found that i have to fire this command at CICS terminal. I want to know how can I get to the CICS terminal.

    KarishmaKapoor20 pointsBadges:
  • 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    

    Tl312820 pointsBadges:
  • 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

    EvandroGodoy5 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • DB2 image copy that is no longer in SYSCOPY on zOS operating system

    We have a tablespace that needs to be restored from an image copy which we have the problem is the image copy is not recorded in SYSCOPY. We also tried doing a UNLOAD FROMCOPY thinking if we got the data out of the image copy we would be able to load it back into the table. That also failed with...

    EPPERSON5 pointsBadges:
  • 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.

    Ari200940 pointsBadges:
  • 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?  

    Geetika12315 pointsBadges:
  • 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...

    Eligin20 pointsBadges:
  • continuous ping from mainframe

    Can I do a continuous ping from an IBM mainframe z/OS. I can do nnnn iterations, but I want to do a continuus ping.

    Madan5 pointsBadges:
  • 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 ?

    SR045 pointsBadges:
  • Scalar functions in GROUP BY

    Is there a reason why I cannot use a SCALAR function in a Group BY clause? I have a table with a column that is of type timestamp. I want to get a count of all dates for which there are multiple rows. So I devise a query of the sort SELECT COUNT(*), DAYS(TMSTP_COL) FROM MYTAB A GROUP BY...

    Sumithar0 pointsBadges:
  • 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 or may not process the 6...

    ITKE352,420 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following