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

Erredi5 pointsBadges:

Flashcopy error message ADR316W when backing up target volume

I'm new to DFSMS Flashcopy and would like advice. I used the following JCL step to backup a source volume to target volume. //STEP901A EXEC PGM=IKJEFT01, // REGION=0K //SYSTSPRT DD SYSOUT=* //SYSUADS DD DSN=SYS1.UADS, // DISP=SHR //SYSLBC DD DSN=SYS1.BRODCAST, // DISP=SHR //SYSTSIN DD * FCESTABL...

Liberty5 pointsBadges:

DB2 Automated Utilities – Vendor selection

We use the IBM utilities suite and our own in-house utilities automation for DB2 v7. Our automated utilities is now draining us with heavy maintenance and since V7, there are still a few holes that could cause us some serious damage if not fixed in the near future. However, with V8, we would...

Galvtx0 pointsBadges:

Z10 migration to z114

Are there any issues migrating from a z10 BC to a z114 with both running z/OS 1.13

johnrcliff5 pointsBadges:

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

ShuroK30 pointsBadges:

Performance after mainframe upgrade issue.

Our shop is planning an upgrade from an IBM 2096-T03 Z/os machine to a 2096-R04. As far as I am aware, so far only the prerequsite PTF's have been applied. We have noticed an average of 25% increase in our IDMS transaction times since the PTF's have been installed. Has anyone gone through a similar...

NLSparky5 pointsBadges:

Intermittent Error using FTP/TLS

Our shop has several jobs that are running on a z/OS system in which we are transfering data to an FTP server. Other than a difference in file names being transfered, the FTP script is virtually the same. Unfortunately, we are having a problem with one specific job. When attempting to log onto the...

Spencer7565 pointsBadges:

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

Cdthorpe5 pointsBadges:

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

Clauk5 pointsBadges:

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

Jackk5 pointsBadges:

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:

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: