 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 11 matches |
| Author | Message |
|---|---|
 Topic: How to reduce the file size |
|
| analyst Replies: 4 Views: 6939 |
 Forum: Job Control Language(JCL) Posted: Tue Oct 04, 2011 9:04 pm Subject: Thanks. |
| Thanks all for your replies.The same file if created with FB with LRECL is taking 45 MB.If I create teh same file with VB then it is taking 3 MB of space.
The dataset created with LRECL = 2000 beca ... |
|
| Topic: How to reduce the file size |
|
| analyst Replies: 4 Views: 6939 |
Forum: Job Control Language(JCL) Posted: Thu Sep 29, 2011 12:35 am Subject: How to reduce the file size |
| I am having a JCL which is creating PS with RECL 2000.This JCL is being called by many reporting programs.The length of the reports vary from 100-2000.
When I am generating a report with RECL = 100 ... |
|
| Topic: Conversion of Oracle tables to DB2 tables |
|
| analyst Replies: 1 Views: 2095 |
Forum: Database Posted: Tue May 17, 2011 4:22 pm Subject: Conversion of Oracle tables to DB2 tables |
| Our Client is using Oracle on open Systems and DB2 V 8.1 on mainframe.There is requirement in mainframe to select the data on Oracle.
The approach we are following is ask Open Systems to send the d ... |
|
| Topic: How to find out CPU Usage of current jobs |
|
| analyst Replies: 4 Views: 11517 |
Forum: Job Control Language(JCL) Posted: Tue Feb 15, 2011 2:56 pm Subject: How to find out CPU Usage of current jobs |
| Some times my job is taking so much Elapsed Time although CPU time is same.When I asked the performance team they informed that is another job is in Loop. Could anybody please let me know,how to check ... | |
| Topic: Trigger mechanism to write to MQ When a row is inserted Db2 |
|
| analyst Replies: 6 Views: 5481 |
Forum: Database Posted: Wed Mar 31, 2010 7:12 pm Subject: Trigger mechanism to write to MQ When a row is inserted Db2 |
| dbz..My batch process is a single program,but it does lot of calculations but it is a single program/job ..Thanks for the load information .[Db2 trigger is an extra load]
Ron: Different IMS DC (DB ... |
|
| Topic: Trigger mechanism to write to MQ When a row is inserted Db2 |
|
| analyst Replies: 6 Views: 5481 |
Forum: Database Posted: Wed Mar 31, 2010 7:14 am Subject: Trigger mechanism to write to MQ When a row is inserted Db2 |
| I need design help in the following case:
I am writing records into DB2 Table from different transactions.Once the records are written into a table I need to put that data into MQ Message on real t ... |
|
| Topic: XML Support for DB2 |
|
| analyst Replies: 1 Views: 1703 |
Forum: Database Posted: Mon Jul 20, 2009 8:17 am Subject: XML Support for DB2 |
| Whether DB2 Version 7.2 or 8.1 supports XML?Did anybody used XML dumps and tried to convert the XML to relational DB.could anybody please share some more info on this.. | |
| Topic: Application Development Facility (ADF) Documents |
|
| analyst Replies: 0 Views: 1709 |
Forum: IMS Posted: Wed Nov 14, 2007 7:39 am Subject: Application Development Facility (ADF) Documents |
| IBM has stopped supporting ADF.But my new project uses ADF.COuld anybody let me know any links for ADF material.Thanks in advance.If anybody has material could you please send it to arao123@rediffmail ... | |
| Topic: Parameters for degradation of SQL Performance. |
|
| analyst Replies: 4 Views: 2270 |
Forum: Database Posted: Tue Sep 04, 2007 7:03 pm Subject: Thanks to you all |
| Thanks to you all for your valuable responses.I will start answering with EXPLAIN and proceed with REORG,RUNSTATS,monitoring etc.. | |
| Topic: Parameters for degradation of SQL Performance. |
|
| analyst Replies: 4 Views: 2270 |
Forum: Database Posted: Tue Sep 04, 2007 7:48 am Subject: Parameters for degradation of SQL Performance. |
| " There is an existing SQL but of late suddenly, it is taking too much time,without changing any thing in that.What will be the causes and how you go about increasing the performance of that?&quo ... | |
| Topic: Difference between SQL Codes -911 and -913 |
|
| analyst Replies: 1 Views: 3255 |
Forum: Database Posted: Mon Aug 27, 2007 4:44 am Subject: Difference between SQL Codes -911 and -913 |
| Could anybody tell me what is the difference between SQL Code -911 & -913.This one was asked in an interview,but I could not get the correct answer after going thru some books.
-911: The curren ... |
|
All times are GMT - 5 Hours |