db2dbazos.blogspot.com
DB2 DBAThis Blog is dedicated to DB2 DBAs on mainframe Platform
http://db2dbazos.blogspot.com/
This Blog is dedicated to DB2 DBAs on mainframe Platform
http://db2dbazos.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
0.4 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
18
SSL
EXTERNAL LINKS
0
SITE IP
172.217.11.33
LOAD TIME
0.407 sec
SCORE
6.2
DB2 DBA | db2dbazos.blogspot.com Reviews
https://db2dbazos.blogspot.com
This Blog is dedicated to DB2 DBAs on mainframe Platform
db2dbazos.blogspot.com
DB2 DBA: January 2013
http://db2dbazos.blogspot.com/2013_01_01_archive.html
This Blog is dedicated to DB2 DBAs on mainframe Platform. Saturday, January 12, 2013. Restrict users to create implicit databases like DSN00001 . Application developer can create their own tables taking away controls from DBA. Recently while analyzing the Catalog table space we found many tables and databases created by application developers for their testing purpose. They are sitting on the space pool that the DB2 catalog is using. This is a wired situation from a DBA point of View. How it is possible:.
DB2 DBA: May 2012
http://db2dbazos.blogspot.com/2012_05_01_archive.html
This Blog is dedicated to DB2 DBAs on mainframe Platform. Tuesday, May 8, 2012. UNAVAILABLE RESOURCE REASON 00E70081. Here I come again! You want to drop or alter a Table. But you are getting "DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00E70081. TYPE OF RESOURCE 00000A00. Let's see what is reason code: 00E70081. System action: The requested operation is not performed. On quering the resource type:. TYPE Code Type of Resource Name, Content,Format.
DB2 DBA: Restrict users to create implicit databases like DSN00001 ...
http://db2dbazos.blogspot.com/2013/01/restrict-users-to-create-implicit.html
This Blog is dedicated to DB2 DBAs on mainframe Platform. Saturday, January 12, 2013. Restrict users to create implicit databases like DSN00001 . Application developer can create their own tables taking away controls from DBA. Recently while analyzing the Catalog table space we found many tables and databases created by application developers for their testing purpose. They are sitting on the space pool that the DB2 catalog is using. This is a wired situation from a DBA point of View. How it is possible:.
DB2 DBA: Backup Failed with REASON 00C200E1
http://db2dbazos.blogspot.com/2010/08/backup-failed-with-reason-00c200e1.html
This Blog is dedicated to DB2 DBAs on mainframe Platform. Sunday, August 8, 2010. Backup Failed with REASON 00C200E1. Here is another classic example of backup failure with REASON 00C200E1. You will get below message:. DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = DSQDBCTL. DSNUGUTC - COPY TABLESPACE DSQDBCTL.DSQTSCT1 COPYDDN DSQTSCT1. DSNUGBAC - RESOURCE UNAVAILABLE. NAME QMF220.DSNDBC.DSQDBCTL.DSQTSCT1.I0001.A001. DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E4010A'. As yo...
DB2 DBA: Know the power of REPAIR utility in DB2
http://db2dbazos.blogspot.com/2010/07/know-power-of-repair-utility-in-db2.html
This Blog is dedicated to DB2 DBAs on mainframe Platform. Saturday, July 24, 2010. Know the power of REPAIR utility in DB2. Hello my blog readers. In this blog, I am going to explain how you can utilize REPAIR utility the most. Everybody know REPAIR utility is popularly used for resetting the pending states of Index and Tablespaces. Everybody know REPAIR utility is popularly used for resetting the pending states of Index and Tablespaces. STEP3 EXEC DSNUPROC,UID='SSTRR',. DTSG10.TS1 RID (X'0000000503').
TOTAL PAGES IN THIS WEBSITE
18
DB2 Database Repair | Recovery | Restore
Repair corrutped DB2 Database. DB2 97 Database Recovery. Looking to repair corrupted or damaged DB2 database? How the damaged or corrupted DB2 database can be repaired? What are the features of DB2 Database Repair software? Possible Reasons For these Un-accessibilities Are:. Virus infections or attacks. Abnormal shutdown of system or server. Software or hardware related issues. Database header corruption etc. Some of the features that it includes are:. Efficiently repairs huge and large databases.
Talk about DB2
A blog that discusses DB2 stuff. Saturday, December 16, 2006. Strange: Group privileges are ignored for CREATE VIEW. Does not have the privilege to perform operation "SELECT" on object. If a user receives this error while creating views, make sure the user is granted SELECT privilege individually. Group privileges are not considered for any table or view specified in the CREATE VIEW statement. No, its not a bug. Its documented :). Saturday, December 09, 2006. Thursday, November 03, 2005. Db2 all " $noden...
Welcome to www.db2dba.org
Welcome to DB2DBA.org. This Site is under construction and should be up soon. Meanwhile if you need to contact me you can reach me @ 571-295-5DBA. Please go to http:/ resume.db2dba.org. To see my current Resume. Please use provided userid and password.
DB2 BLOG FOR LUW
DB2 BLOG FOR LUW. Wednesday, October 12, 2011. SQL2104N The ADMIN MOVE TABLE procedure could not be completed at this time by this user. Reason code: "9". SQLSTATE=5UA0M. So Here is the new error that I encountered when I executed a procedure in my testing database. CALL SYSPROC.ADMIN MOVE TABLE('SEP11','ALL DATA SEP11', 'USERSPACE1','USERSPACE1','USERSPACE1',' , ' , ' , ' ,' ,'MOVE'). To know more details about the above procedure please check out this link. SYSPROC.ADMIN MOVE TABLE. CALL SYSPROC.AD...
Welcome to ACE DBA Consulting Inc
Of the 21st century. ACE DBA’s solutions are for any enterprise which has database on any platform. ACE has expertise in DB2 UDB On Linux , Unix and Windows , Mainframe, VM/VSE , Z/OS, DPF and I series, ORACLE, SYSBASE, SQL SERVER, ACCESS, Excel. We conduct training for these databases ORACLE, DB2, SQLSERVER, COGNOS and ACCESS. We can have training at our premises or we can conduct corporate training at your premises. Which statement is incorrect for db2 tablespaces on LUW? D: None of the above.
DB2 DBA
This Blog is dedicated to DB2 DBAs on mainframe Platform. Saturday, January 12, 2013. Restrict users to create implicit databases like DSN00001 . Application developer can create their own tables taking away controls from DBA. Recently while analyzing the Catalog table space we found many tables and databases created by application developers for their testing purpose. They are sitting on the space pool that the DB2 catalog is using. This is a wired situation from a DBA point of View. How it is possible:.
db2Dean Home Page
Db2Dean a.k.a. Dean Compher a.k.a The Dean of DB2 is here to answer your DB2 Questions! March 2018: Think Conference. Just for Grins Watch:. DB2 Infomercial by db2Dean. Add your insights to the:. Get the Free Data Studio! Get DB2 Express-C Here! Db2Dean Discusses Big Data. Query Cloud Db2 Using REST APIs. 22 March, 2018. And API Data in your Datbase. I’ll now discuss how to use the main document called IBM Db2 Warehouse on Cloud REST API. Example 1. Get the token for subsequent commands. As you can see t...
DB2 Remote Database Administration|Certified Manager
Jim Woltz, founder. DB2 Database Administration for Linux, Unix and Windows. Full and Fractional DBA Service. Versions: 7, 8.2,9.1,9.5,9.7,10.1. Our goal is to:. Provide thorough and conscientious DBA support. To ensure your goals are met or exceeded. 20 years of experience. Linux, UNIX, Windows.
Deborah Beebe Design
Ldquo;To design is much more than simply to assemble, to order, or to edit; it is to. Add value and meaning, to illuminate, to simplify, to clarify, to modify, to dignify,. To persuade, and perhaps, even to amuse.”—Paul Rand. Colin & Co. Midnight in the Garden. 2015 Deborah Beebe Design.
Hosted By One.com | Webhosting made simple
Domain and Cheap Web Hosting by One.com. Db2development.com is hosted by One.com. Web hosting and domain by One.com. Affordable web hosting and domain plans available at One.com. Build your own website with Web Editor or choose a 1-click blog installation. Whatever you choose, One.com. Is dedicated to our customers' satisfaction with 24/7 chat support.
