Mainframe OS

460

Solutions

614

Contributors

A mainframe operating system is networking software infrastructure that allows a mainframe computer to run programs, connect linked machines, and process complex numerical and data-driven tasks. Modern mainframe design is generally defined by redundant internal engineering, extensive input-output facilities, strict backward compatibility with older software, high hardware and computational utilization rates and high stability and reliability. Well-known operating systems include IBM z/OS, z/VM, zTPF, z/VSE, OS/390, and their predecessors, along with MCP for Unisys ClearPath, and NonStop OS/Guardian on HP/Tandem, and questions regarding the IBM midrange operating system called IBM i, OS/400, and i5/OS.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hello Gurus,

I have a a vanila batch JCL that interacts with DB2. This JCL stream has scratching my head because a similar code works with no error and this particular one fails with "IEFC601I INVALID JCL STATEMENT". I have looked deeply but can't see anything wrong with the JCL or the DB2 SYSTEM statement. Can I get a few eyes on this problem to see what I may be missing?
Here is the JCL & the error Messages (at least some of them):

//OGSETUTM  PROC
//*************************************************
//*  FIND ALL TABLESPACES FOR SPECIFIED TRACK     *
//*************************************************
//*
//PSTEP01  EXEC PGM=IEFBR14                                             00058100
//DD01     DD DSN=PRD.F&SSNODE..OSCR.OG1LIST.TSPACEO,                   00058200
//            DISP=(OLD,DELETE,DELETE)                                  00058300
//*        DD DSN=PRD.F&SSNODE..OSCR.OG1LIST.TSPACEO,                   00058400
//*           DISP=(OLD,DELETE,DELETE)                                  00058500
//*
//PSTEP02 EXEC PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB  DD  DSN=SYS2.DB2.&LOADIR..SDSNLOAD,DISP=SHR
//SYSTSPRT DD  SYSOUT=*
//SYSREC00 DD DSN=&&OUTSPACE,UNIT=TEMP,DISP=(NEW,PASS),
//            SPACE=(CYL,(1,1),RLSE),
//            DCB=(RECFM=FB,LRECL=80,BLKSIZE=0)
//SYSPRINT DD  SYSOUT=*
//SYSPUNCH DD  DUMMY
//SYSTSIN  DD *                                                        <<<-------Says "IEFC601I INVALID JCL STATEMENT" from here through
  DSN…
0
Hi Gurus,

We have tried to use symbolic parameters while defining LISTDEF command options such as shown below:

LISTDEF CPYLIST  INCLUDE TABLESPACE &dbname.&tsname.   Can someone with the knowledge and have tried this confirm if it is possible to use substitution parameters for LISTDEF.

Thank you
0
Hello again, Gurus's,

This is really part 2 of an earlier thread...
I have a regular fix format flat file that contains DB2 commands such as shown below:

1-----------------------------------------40----------------------------------------------------------------80 columns
 -START DB(PRDDDEV1) SPACENAM(PRDSCAM1) ACCESS(UT)
 -START DB(PRDDDEV1) SPACENAM(PRDSCJR1) ACCESS(UT)

I can use IKJEFT01 for executing a DB2 START command inline and individually. But I need to be able to read this flat file and execute the db2 start cmmand that you see above.  I have tried using IKJEFT01 such as shown example-1 (WITHOUT dnstiaul)

EXAMPLE-1:  (Fails nothing happens)
//JSTEP04 EXEC PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB  DD  DSN=SYS2.DB2.TEST.SDSNLOAD,DISP=SHR
//SYSTSPRT DD  SYSOUT=*
//*YSPRINT DD  SYSOUT=*
//SYSPRINT DD DSN=OUTFILE,
//            DISP=(NEW,CATLG,DELETE),
//            SPACE=(CYL,(1,1),RLSE),
//            DCB=(RECFM=FB,LRECL=80),
//            UNIT=SYSDA
//SYSPUNCH DD  DUMMY
//SYSTSIN  DD *
 DSN SYSTEM(prd01)
//SYSIN    DD DSN=&&OUTSPAC1,DISP=(OLD,DELETE)
 END
/*

I have also tried using IKJEFT01 and invoking DSNTIAUL as show in example-2 but got error messages for my trouble.
EXAMPLE-2:  (Gets error messages)
//JSTEP04 EXEC PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB  DD  DSN=SYS2.DB2.TEST.SDSNLOAD,DISP=SHR
//SYSTSPRT DD  SYSOUT=*
//*YSPRINT DD  SYSOUT=*
//SYSPRINT DD DSN=OUTFILE,
//            DISP=(NEW,CATLG,DELETE),
//            …
0
HI all,

My current set involves always having to add/delete tablespaces every time there is a change. As you can see, I have had to hard code the tablespaces that I need as shown below:
//UTL1000U EXEC PGM=IKJEFT01,DYNAMNBR=20                                00012003
//*                                                                     00012003
//*  START TABLESPACES IN UTILITY MODE FOR EXCLUSIVITY                  00012003
//*                                                                     00012003
//SYSTSPRT DD  SYSOUT=*                                                 00012003
//SYSPRINT DD  SYSOUT=*                                                 00012003
//SYSTSIN  DD  *                                                        00012003
      DSN SYSTEM(DBO1)                                                  00012003
       -START DB(PRD1FFEV1) SPACENAM(PD1SCAM1) ACCESS (UT)
       -START DB(PRD1FFEV1) SPACENAM(PD1SCJR1) ACCESS (UT)
       -START DB(PRD1FFEV1) SPACENAM(PD1SDNF1) ACCESS (UT)
       -START DB(PRD1FFEV1) SPACENAM(PD1SGCT1) ACCESS (UT)
      END  

What I will like to do is extract and dynamically build the START string, call the DB2 START command. I will like to know if I can do the following and if anyone can show me how best to achieve my goal of dynamically start my tablespaces in ACCESS (UT) mode?
What I have in mind is as follows:
//UTL1000U EXEC PGM=IKJEFT01,DYNAMNBR=20                                00012003
//*                 …
0
Hey

Is it possible to run a command line/file from a Windows computer - to reset a password on a user on our AS400?

Today our supports use Personal Communication - (logon - find the user - and reset the password)

We would like to make this a bit easier... but how? (script?) - only entering the name of the user...

Thanks
0
Hell again Gurus, seeking some answer to a utility issue that I have.

(1) When we refresh out TEST/QA environments (4 seperate DB2 environments) with prod data, DB2 UNLOAD utillity is used and several UNLOAD/SYSPUNCH datasets are created. We have a maintenance reason to merge all the SYSPUCH datset into one, single SYSPUNCH datafile.

(2)  What we would like to do is find a way to pull in a list of datasets beginning with PRD.FDBO1.OSCR.UNLOAD.PRD* and then generate the SYSUT1 DD statement for an IEBGENER. The last node of the UNLOAD datafile name is the tablespace name prefixed by PRD*. We currentl have the tablespace name hardcoded for the 4 environments and in seperate directories. We would like to find a generic method of building the jobs that we need with only 1 set of JCL for all the 4 environment. How can we accomplish this task?

 Here is what we currently have hard coded in the JCL as an example:
 
//JSTEP01  EXEC PGM=IEBGENER
 
//SYSPRINT DD SYSOUT=*
 
//SYSIN    DD DUMMY
 
//SYSUT1   DD DISP=SHR,DSN=PRD.&FNODE..OSCR.PRDUNLD1.PRDSCAM1.PUNCH
 
//         DD DISP=SHR,DSN=PRD.&FNODE..OSCR.PRDUNLD1.PRDSCJR1.PUNCH
 
//         DD DISP=SHR,DSN=PRD.&FNODE..OSCR.PRDUNLD1.PRDSDNF1.PUNCH
 
//         DD DISP=SHR,DSN=PRD.&FNODE..OSCR.PRDUNLD1.PRDSGAJ1.PUNCH
 
//         DD DISP=SHR,DSN=PRD.&FNODE..OSCR.PRDUNLD1.PRDSGCT1.PUNCH
 
//         DD DISP=SHR,DSN=PRD.&FNODE..OSCR.PRDUNLD1.PRDSMSR1.PUNCH
 
//         DD …
0
Hi all,

Which distributed edition of DB2 LUW client for windows is right for working with DB2 v8 Z/OS?
0
I've been out of Mainframe CICS programming for about 10 years and now am contemplating a possible CICS process where;

  * Every 15 minutes a process runs that reads a DB2 table (Cursor driven) and outputs
     records to a sequential file as needed.
  * After this process runs the sequential output file needs to be available for another
     non-CICS process to work with it and clear the records when done.

Is this possible within CICS? of course this sounds like its tailor made for a batch process but was thinking it might be cleaner if it could be accomplished within CICS to bypass all the outputs to JES due to the number of jobs that would run and maybe easier to setup a 15 minutes timer to invoke the necessary transaction to execute the program and process and bypass the batch scheduler.

If I recall correctly an Extrapartiion TDQ can be defined for the sequential output file BUT can it be accessed/updated by a non CICS process since it will be allocated to the CICS region?

Is there another means to be able to do this or is it simply a pie in the sky idea?

Thanks for any insights!
Bill
0
Hello Experts,

DB2 V8.1 (NFM) on z/OS, some CA Tools like RC/Migrator,REOG,PDA,Fast Unload/Fast Load,etc

I am looking for options to perform alter of a series of existing DB2 table that has data.  I am thinking about few options, would like to know the pros and cons from your past experience. If someone has done some benchmark and would like to share please do.

We would like to keep all the changes (I mean all versions or old values).

What tools are there that if available to me I can use rather than do this manually and risk potential error and loss of critical data.

1. Change data capture - we used it to replicate but I am not sure how effective it will be to capture table column level changes. I understand it will capture all DML changes we are ok with that but doe it also capture column size changes?
2. The volume of the table might not be that big according to the mainframe standards :) (8 -10 million per table - 48 tables), tables may have RI and triggers and stored procedures.
3. How about Audit changes? yes with the proper audit class turned on, how much effort to process?
4. Getting a tool that does it all, I know we have to pay for it however if that saves our time and give some nice features that is something worth looking into.
I am looking into couple of products, would like to get some real-time good/bad experience
5. Should I just go the Unload/drop/recreate tables(columns)/reload?

I am looking for the most effective step by step …
0
Hello All,

I am on DB2 v8 for z/OS and CA Fast unload and Fast load available. For performance and maintenance reasons, I need to Unload from Production to Test DB2 and I will like to use DB2 LISTDEF funtionality. Can anyone show with examples how the setup can be done?
Please I need real code examples, not just discussing the topic.

All response will be highly appreciated.

Thank you.
0
Hi all,

I have a SQL that joins two tables in a declare cursor statement in a COBOL program . During open cursor call, we are observing a high getpage count (millions of getpages), high CPU and I/O numbers and taking about 7 minutes to complete.

Can anyone share some thoughts and ideas for possible cause and potential solutions? What are the areas/things to research/review for possible causes and to remedy this performance slow-down?

Any question or more info, please let me know.

Thanks
0
Hi all,

Problem Statement:

My shop is currenttly performing a thorough testing of a critical set of applications and a major component of the test
strategy is to have the ability to request a FULL recovery of ALL databases from any given point in time - one day ago, two days ago or even two weeks ago up to current day from PROD to TEST. This is (for now) strictly a Monday to Friday system. But during the weekdays,
the system cannot be down and no outage can be scheduled except for nightly batch window which is already crowded.So Backup time is at a premium here.
The current method used to refresh the test environment is said to be very slow, taking as much as 14 hours to complete. The refresh is performed using DB2 UNLOAD/LOAD (DSNUTIL??) utility.

Current Backup state:

Weekly Full Image Backup on Wednesdays & Fridays nights.
Monthly Full Image Backup last Saturday of the month
All other days Incremental Image backups

NOTE: We do not have a Incremental Image merge process inplace. Why, I don't know. I inherited this setup. We also do not have any backups on the weekend.

The following Toolset are available to me (and I have not used most of the tools myself except for the CA RC/products when it was still owned by Platinum)

CA Fast Load for DB2 for z/OS
CA Fast Recover for DB2 for z/OS
CA Fast Unload for DB2 for z/OS
CA Log Analyzer for DB2 for z/OS
CA Merge/Modify for DB2 for z/OS
CA Plan Analyzer for DB2 for z/OS
CA Quick Copy for DB2 for …
0
We need to make an ODBC connection from an IBM System i to a remote Microsoft SQL 2008 R2 database.  I am having problems finding any documentation on connection setup for this on the i Series side.
0
Can MSMQ send messages to and from an MVS mainframe using the IDMS operating system and TSO?
0
I have went through and setup SSL connections on almost all my clients that access our AS400 but now I want to see if there is anyone that is not using SSL to make the connection so I can change their configuration. Is there a way on the 400 to see who is not connecting with SSL?
0
Hi all,

I have a DB2 VSAM dataset that our MODIFY utility had removed the SYSCOPY entry and I am not able to restore the regular method. But I still have the physical VSAM dataset and I want to use the dataset to restore the tablespace(s). Can someone share the step-wise JCL to complete this recovery?

Thanks
0
Hi everyone,

    Recently our director retired, and he was the only one that really knew anything about our VMS system, we are slowly migrating everything off of it, but I have an issue right now.  

We have a program that he had written in basic that FTPs a couple files over and makes necessary changes to them.  The problem is that the program used an old IP address in there for the server it is getting the files from.  I can edit the source code to the .bas file, but I cannot figure out how to compile it.  I tried $BASIC FILENAME
 
but I get an error for the line "%INCLUDE "MVPMAP:MVP_EXTRACT_MAP.BAS"

%BASIC-E-ERROPEFIL, error opening file MVPMAP:MVP_EXTRACT_MAP.BAS
-BASIC-F-DEV, error in device name or inappropriate device type for operation
at line number 21 in file ALLEN0$DKD100:[MVP_REAL.BAS]MVP_EXTRACT_NEWIP.BAS;1
0
We are planning to install our tivoli software that we are currently running on a VMware enviorment onder suse linux 11 also under a IBM Power 7(LINUX) partition.
while the operating system is also Suse linux, we believe there is a architecturial difference.
intel v.s. risc. So there are some open questions for us:

Does Power linux works with Motif under Suse Linux 11
What are dependencies and c+ lib.
Does the NX server works with  Power linux or other grafiscal tools
Does DB2 works the same under this platform
0
How do I copy a Z/OS PDS file to a flat file?  The flat file cannot be compressed.  The flat file will be used as input to a program.
0
Hi,

What's the difference between a rackable server and a blade server in a matter of design, performance, specifications and price?

Thank you!
0
Hello All,

I need to develop a DB2 z?OS performce Trending table to capture DB2 performance statistics over time. The goal here is to enable us to monitor, capture and report/produce excel graphs on performance trends and resource planning use. The iinformation or DB2 data I wil like to capture are but not limited to the following categories:

(1) check the quality of dynamic SQL statements, monitor and assess I/O performance and buffer pools, monitor threads, DDF, plans, packages, objects in restricted state and utility executions, SCA structures, group buffer pools, just to mention a few.
(2) detect conceivable lack of space,
(3) ensure timely recoverability according to SLAs,
(4) monitor BSDS/log activities,

My question is thus:

Do you know of any free or reasonably priced laptop or desktop base tool that can be used for the purpose described above?  

Can anyone share an example, with specifics, about how they have built their trending table(s), what data collection types was used, what reporting tool is being used, frequency of data collection, etc and any other information that is pertinent to developing a trending strategy.

I will appreciate any and all links to information that can be useful for this project and will be especially thankful if someone can share example of what they have done.

Thanks everybody!
0
Hello!, I have a weird situation, we have just upgraded our OS in our iSeries box, from 5.4  to 6.1,, and now users can not access to type some common commands as WRKSPLF, WRKUSRJOB, and previously they could. Let tell you  that also before the change, the user profiles  had  LIMIT CAPABILITIES  as  *YES,, but they could  type those commands,, now  with the new  OS,, they are not able to access to type these commands.  What could happen?
0
I am trying to automate using coded UI and during this I need to read data from Mainframes and compare the data with my front end application.
I tried using the clip board but that does not help as I am not sure that the mainframe data will remain the same. It can change.

Could you please help me with the same.

Thanks!
0
Hi,

I'd like to obtain IBM Certified System Administrator on AIX OS.
I currently cannot attend any class.

Can yo pleas guide me through some good online./useful resources?

Thank you!
0
I have a few users that are remote /

They connect via VPN to our network | then launch Iseries Access to connect 5250 to our As/400.  They also have a Virtual Printer that they start and can print some AS/400 Reports.

Some they cannot and appear through the logs as having AFP commands/content built into the spool file.

There is no such setting on the Virtual Printers to allow for AFP so guessing that it cannot be done that way.

Is there a way to enable AFP on the Iseries Access Virtual Printer?  

Any ideas - would a spool file to PDF program work on the AS/400?

thanks
0

Mainframe OS

460

Solutions

614

Contributors

A mainframe operating system is networking software infrastructure that allows a mainframe computer to run programs, connect linked machines, and process complex numerical and data-driven tasks. Modern mainframe design is generally defined by redundant internal engineering, extensive input-output facilities, strict backward compatibility with older software, high hardware and computational utilization rates and high stability and reliability. Well-known operating systems include IBM z/OS, z/VM, zTPF, z/VSE, OS/390, and their predecessors, along with MCP for Unisys ClearPath, and NonStop OS/Guardian on HP/Tandem, and questions regarding the IBM midrange operating system called IBM i, OS/400, and i5/OS.

Top Experts In
Mainframe OS
<
Monthly
>

No Top Experts for this time period. Answer questions to earn the title!