Versions to be withdrawn from service on June 27, 2014: [crayon-53d21bde1a7dc950876948/] See IBM Withdrawal Announcement ZP12-0021.
Category: DB2 for z/OS
Sun, 25 May 2014 21:38:59 +0200
DB2 11 for z/OS: The SYSPROC.ADMIN_EXPLAIN_MAINT stored procedure maintains EXPLAIN tables under a specified schema. It can be used to: bring all existing EXPLAIN tables to current release format; create missing EXPLAIN tables; create a new set of EXPLAIN tables; create a new set of aliases on the EXPLAIN tables; drop existing EXPLAIN tables; ...
Sun, 25 May 2014 21:32:07 +0200
The DB2 sample program DSNTIAUL is dynamic SQL processing application that is often used to unload data from DB2 tables to an externalized format. Â DSNTIAUL also generates a LOAD control statement that can be used in by Â the DB2 LOAD utility to load the externalized data back into DB2. Currently DSNTIAUL ...
Thu, 24 Apr 2014 14:46:12 +0200
IBM freut sich, Sie zur FrÃ¼hjahrstagung des deutschen GSE DB2 z/OS Guides nach WÃ¼rzburg einladen zu kÃ¶nnen. Die Veranstaltung steht diesmal unter dem Motto "DB2 z/OS V11"! WÃ¤hrend der GSE Tagung werden viele interessante VortrÃ¤ge rund um DB2 V11 von Kundensprechern die auch am Early Support Programm teilgenommen haben, IBM Sprechern ...
Thu, 27 Mar 2014 10:59:30 +0100
Loading data of DB2 z/OS internal format into a DB2 Linux/Unix/Windows database became very easy. Either you use DB2 Connect to connect from any DB2 Linux/Unix/Windows to DB2 for z/OS. But this costs you a separate license fee. For a distinct class of DB2 LUW server (e.g. on AIX) IBM supplies ...
Tue, 18 Mar 2014 21:50:26 +0100
Does your application has to check cerrtain authorzation id's for certain access rights needed? Following SQL shows some ways how to proceed: [crayon-53d21bde1c247986386254/] In this sample the SQL's have to check incoming userid's for having .. L0nnnnnn or F0nnnnnn where n=0-9 except first letter should not have any other letter or special character Any comment? Do ...
Sun, 16 Mar 2014 22:15:22 +0100
Accessing DB2 for z/OS or DB2 for iSeries from client on DB2 for Linux/Unix/Windows? Do you Â experience troubles accessing then remote server database? Missing a license file? How to install and custimize? DB2 JDBC driver is not licensed for connectivity by file db2jcc_license_cisuz.jar ERRORCODE=-4472 SQLSTATE=42968 http://www-01.ibm.com/support/docview.wss?uid=swg21413734 See chapter "Installing the IBM Data ...
Thu, 13 Mar 2014 13:59:38 +0100
Extended DB2 DRDA Security: Managing TCP/IP-based connection requests Prepare requestors for access requests using extended security IPNAMES LOCATION USERNAMES Setting DB2 for z/OS DRDA AR to use encrypted passwords Using ICSF on z/OS Using PassTicket How RACF Processes the Password or PassTicket The role of TCPALVER system parameter Troubles using PassTickets Unable to obtain a PassTicket - 00D31059 Invalid PassTicket passed - 00F30085 Protected ...
Sat, 01 Mar 2014 16:01:43 +0100
The purpose of the white paper is to compare mainframe-based and distributed-based job schedulers and to assess the readiness of Microsoft Windows-based job scheduling technology to manage workloads at the enterprise level. The paper can also help IT organizations that plan to migrate mainframe workloads to the Windows Server platform ...
Thu, 13 Feb 2014 10:34:36 +0100
Do you need to convert decimal value to hexadecimal representation? Then you should try this: [crayon-53d21bde1c78c505545714/] Sample data displayed in a GUI (e.g. DbVisualizer): The result is of type VARBINARY. You ...
Thu, 06 Feb 2014 21:48:50 +0100
The "CA Performance Handbook for DB2 for z/OS"Â handbook helps DB2 performance tuners to complete the following tasks: Design databases for high performance. Understand how DB2 processes SQL and transactions, and tune those processes forÂ performance. For database performance management, the philosophy of performance tuning beginsÂ with database design and extends through the database and application ...
Thu, 06 Feb 2014 12:05:36 +0100
New document published: DB2 11 for z/OS new way of archiving data DB2 11 for z/OS new way of archiving data: With DB2 11 for z/OS user can create archive tables to manage historical data for existing tables that is not often referenced. Read more about new table type called â€˜archive tableâ€™....
Tue, 04 Feb 2014 22:08:51 +0100
Work File http://www-01.ibm.com/support/docview.wss?uid=swg1PM17336 Enhancement of the process for creating Work File table spaces during installation and migration. DB2 9 and 10 for z/OS http://www-01.ibm.com/support/docview.wss?uid=isg1II14587 Work File Recommendations. DB2 9 and 10 for z/OS Keywords: Work File, Sortwork, DSNDB07, DGTT, TEMP Space ...
Tue, 04 Feb 2014 22:01:35 +0100
DB2 10 for z/OS customers who want a basic Â tool for evaluating DB2 audit records: PI05578: Enhance DSN1SMFP to support DB2 10 for z/OS: http://www-01.ibm.com/support/docview.wss?uid=swg1PI05578 For more details on how to use DSN1SMFP, see article "DSN1SMFP with DB2 11 for z/OS â€“ revival of a dead".
Wed, 20 Nov 2013 20:30:01 +0100
Starting in z/OS V1R13, IEBCOPY is no longer APF-authorized. It does not need to be run from an authorized library, and calling programs do not need to be APF-authorized. However, In V1R12 IEBCOPY is ...
Thu, 10 Oct 2013 10:32:47 +0200
In january 2007 the IBM DB2 PTF PK34261/UK20793 introduced DSN1SMFP, a DB2-supplied application for processing DB2 trace data into reports that are useful for evaluating and auditing the DB2 environment for Common Criteria. This is very useful if you have no or restricted access to performance reporting tools likeÂ OMEGAMON XE ...
Tue, 01 Oct 2013 23:32:56 +0200
IBM published the planned general availability date for IBM DB2 11 for z/OS:Â October 25, 2013 For more details see IBM EMEA Announcement ZP13-0480, dated October 1, 2013: http://www.ibm.com/common/ssi/rep_ca/0/877/ENUSZP13-0480/ENUSZP13-0480.PDF
Tue, 27 Aug 2013 22:41:16 +0200
Latest DB2 10 for z/OS redbooks have been updated: DB2 10 for z/OS Performance Topics, last updated 23 Aug 2013 Changed information Correction in 7.5, â€œDynamic SQL literal replacementâ€ on page 212 for JCC driver ...
Thu, 01 Aug 2013 10:37:23 +0200
Please follow the direct link to IBMâ€™s download pages of IBM Data Studio Client 4.1 ClickÂ here. Use IBM Installation Manager to select, download, and install only the code, features, or product extensions that you want. Product extensions allow you to extend your install beyond the ...
Mon, 29 Jul 2013 20:28:56 +0200
Do you want to compare DB2 Linux/Unix/Windows databases, structures, contents or configurations. Or do you want to compare table data or structures with DB2 for z/OS?Â Here's list of products which could be useful: Embarcadero DBÂ Change Manager 6.x: Does not support DB2 for z/OS, but ...
Thu, 25 Jul 2013 11:09:55 +0200
Nutzen Sie bereits das volle WertschÃ¶pfungspotential Ihrer DB2 Systeme?Â Was gibt es Neues in der DB2-Entwicklung und wie kÃ¶nnen Sie davon bestmÃ¶glich profitieren? Die DB2 Aktuell 2013 bietet Ihnen Antworten auf diese Fragen und: Zwei Tage ...
Thu, 30 May 2013 20:23:41 +0200
SQL check for unused indexes! Before dropping indexes, verify that following PTF's are installed. RA10 PSY UK76968 UP12/03/27 P F203 R910 PSY UK76969 UP12/03/27 P F203 If not installed, LASTUSED is not being updated when an index is used to enforce a referential integrity constraint. [crayon-53d21bde1cc19697008982/]
Fri, 26 Apr 2013 18:45:29 +0200
The DB2 symposium fills the gap between classic conferences and workshops. In classic conferences many topics are covered, but each speaker has only a limited time for each topic. Interaction between speakers and attendees is normally restricted. In a workshop it is the other way around. Two, three or more ...
Fri, 26 Apr 2013 18:19:07 +0200
IDUG DB2 Tech Conference in Barcelona, Spain 2013 Barcelona, Spain October 13-18, 2013 Call For Presentations: You can submit your abstracts by clicking here. IDUG DB2 Tech Conference in Berlin Wrap Up Article: The Conference was a great success attracting attendees who came together to hear about the latest ...
Sat, 30 Mar 2013 22:16:07 +0100
IBM provides "The IBM DB2 and IMS Tools Product Lifecycle matrix" to Â display the marketing and support services available over the life of z/OS-based products. You can click the dates that are listed to go directly to the product announcement letter. While every effort is made to provide accurate information, ...