 |
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 15 matches |
| Author | Message |
|---|---|
 Topic: DSN1MSTR message: UNABLE TO DRAIN RESOURCE |
|
| pcsingh_2000 Replies: 8 Views: 9175 |
 Forum: Database Posted: Mon Jun 28, 2010 7:04 am Subject: DSN1MSTR message: UNABLE TO DRAIN RESOURCE |
| We got the same error. Here is the DISPLAY database command for this segmented tablespace
-DISPLAY DATABASE(DFLXPRP1) SPACENAM(SFWST ) LOCKS LIMIT(*) at the time of STOP Pending time. NAME ... |
|
| Topic: Database size calculation |
|
| pcsingh_2000 Replies: 3 Views: 1749 |
Forum: Database Posted: Fri Nov 07, 2008 7:07 am Subject: Database size calculation |
| Hi,
Are you asking size of DBLCST5 database. If, yes.. run the STOSPACE utility on the storage group, this database is using. This will update Space column in sysibm.sysindexes and sysibm.tablespac ... |
|
| Topic: Index space(DSNUCH01) of SYSIBM.SYSCOPY table in Read only |
|
| pcsingh_2000 Replies: 2 Views: 2607 |
Forum: Database Posted: Wed Oct 15, 2008 6:51 am Subject: Index space(DSNUCH01) of SYSIBM.SYSCOPY table in Read only |
| Thanks ...
Actually the job ran successfully by operation support when submitted second time. By using the info from the link... it would be a good idea to display DB at that point of time. |
|
| Topic: Index space(DSNUCH01) of SYSIBM.SYSCOPY table in Read only |
|
| pcsingh_2000 Replies: 2 Views: 2607 |
Forum: Database Posted: Tue Oct 14, 2008 11:36 am Subject: Index space(DSNUCH01) of SYSIBM.SYSCOPY table in Read only |
| Hi,
We got an abend for one backup job while registering the Backup entry in syscopy table as below: 06.04.45 STC03943 DSNT501I - DSNIDBET RESOURCE UNAVAILABLE 369 369 CORREL ... |
|
| Topic: DB2 ODBC |
|
| pcsingh_2000 Replies: 0 Views: 993 |
Forum: Database Posted: Fri May 16, 2008 9:06 am Subject: DB2 ODBC |
| Hi,
One of our user wants to load the excel spread sheet data into DB2 subsystem's table from his local machine by running some scripts. Like other systems, ODBC should be there to connect the data ... |
|
| Topic: REVOKE SYSADM FROM <USERID>; |
|
| pcsingh_2000 Replies: 2 Views: 2004 |
Forum: Database Posted: Fri Mar 28, 2008 11:26 am Subject: REVOKE SYSADM FROM <USERID>; |
| Thanks for the input:
We made the Userid as Installation SYSADM id through one job which make the change in Z-Parm of DB2 subsystem. Here is the member: D710.DSN4.SDSNSAMP(DSNTIJUZ) -- second ... |
|
| Topic: REVOKE SYSADM FROM <USERID>; |
|
| pcsingh_2000 Replies: 2 Views: 2004 |
Forum: Database Posted: Tue Mar 25, 2008 12:44 pm Subject: REVOKE SYSADM FROM <USERID>; |
| Hi,
I have given SYADM authority to a userid. Through that userid, the user created many objects and had bind many packages. Now when I tried to revoke the SYSADM auth from that user, the mainfr ... |
|
| Topic: How to recover a tablespace to a particular timestamp |
|
| pcsingh_2000 Replies: 4 Views: 1448 |
Forum: Database Posted: Fri Mar 07, 2008 9:02 am Subject: How to recover a tablespace to a particular timestamp |
| I got a simillar request from my developement team, where I need to refresh the data from production, prior to one job run. I printed the BSDS and found the closest checkpoint when the job statred. Th ... | |
| Topic: How to recover a tablespace to a particular timestamp |
|
| pcsingh_2000 Replies: 4 Views: 1448 |
Forum: Database Posted: Wed Jan 30, 2008 8:19 am Subject: How to recover a tablespace to a particular timestamp |
| Thanks a lot for valuable input | |
| Topic: How to recover a tablespace to a particular timestamp |
|
| pcsingh_2000 Replies: 4 Views: 1448 |
Forum: Database Posted: Wed Jan 23, 2008 5:48 pm Subject: How to recover a tablespace to a particular timestamp |
| I have a requirement as below:
Suppose I have taken a full backup, then Quiesce. After that there are some insert/update/delete on my table. I can recover upto last quiesce point or to a RBA. B ... |
|
| Topic: Run stats |
|
| pcsingh_2000 Replies: 4 Views: 1929 |
Forum: Database Posted: Fri Nov 09, 2007 12:22 pm Subject: Run stats |
| Runstat collects the statistics like number of records in a table, repeating data, index rows and it's characteristics. that means it is now known to db2 about the data/index present for that tablespa ... | |
| Topic: Primary,Secondary alloc SORTWORK, SYSREC, SYSUT1, SORTOUT |
|
| pcsingh_2000 Replies: 1 Views: 1451 |
Forum: Database Posted: Fri Aug 03, 2007 8:01 am Subject: Primary,Secondary alloc SORTWORK, SYSREC, SYSUT1, SORTOUT |
| Hi,
While running RUNSTATS, REORG for any table by DSNUTILB utility, we need to allocate primary and secondary spaces for SORTWORK, SYSREC, SYSUT1, SORTOUT files. In my job I am using SORTWK01 . ... |
|
| Topic: DSN1MSTR message: UNABLE TO DRAIN RESOURCE |
|
| pcsingh_2000 Replies: 8 Views: 9175 |
Forum: Database Posted: Wed Aug 01, 2007 1:58 am Subject: DSN1MSTR message: UNABLE TO DRAIN RESOURCE |
| I have TMON for DB2in our shop. Any idea for getting history of locking from this tool. | |
| Topic: DSN1MSTR message: UNABLE TO DRAIN RESOURCE |
|
| pcsingh_2000 Replies: 8 Views: 9175 |
Forum: Database Posted: Fri Jul 27, 2007 4:12 am Subject: DSN1MSTR message: UNABLE TO DRAIN RESOURCE |
| Right.. we can find out the Claimers at that point of time. When I got the oppertunity to investigate the thing, by that time, the Claimer was not there. Is there any way to find out the Clamers for t ... | |
| Topic: DSN1MSTR message: UNABLE TO DRAIN RESOURCE |
|
| pcsingh_2000 Replies: 8 Views: 9175 |
Forum: Database Posted: Thu Jul 26, 2007 10:58 am Subject: DSN1MSTR message: UNABLE TO DRAIN RESOURCE |
| Here are some message I have collected from DSN1MSTR while analyzing a contention
with respect to "SOSSD" tablespace for partition 1 as specified by Reason, Type and Name. 02.10.14 STC ... |
|
All times are GMT - 5 Hours |