-
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...
Last updated: -
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...
Last updated: -
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...
Last updated: -
Are there any issues migrating from a z10 BC to a z114 with both running z/OS 1.13
-
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...
-
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...
-
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...
Last updated: -
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...
Last updated: -
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...
Last updated: -
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...
-
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...
Last updated: -
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...
Last updated: -
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...
Last updated: -
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',...
-
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...
Last updated: -
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...
Last updated: -
In which dataset will I be able to find the default tables of DB2 V9 in Z OS
Last updated: -
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...
Last updated: -
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
Last updated: -
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
Last updated: