 |
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 18 matches |
| Author | Message |
|---|---|
 Topic: DB2 RUNSTATS time too long, How to reduce the time? |
|
| abc2000 Replies: 2 Views: 2556 |
 Forum: Database Posted: Tue Aug 08, 2006 9:17 pm Subject: DB2 RUNSTATS time too long, How to reduce the time? |
| DB2 RUNSTATS time too long, How to reduce the time?
We are DB2 for Z/OS V8.10, I have a huge partition tablespace(130GB), I need 500 mins to RUNSTATS on the entire tablespace, My statement is ... |
|
| Topic: db2 how to create database simultaneity ? |
|
| abc2000 Replies: 3 Views: 2996 |
Forum: Database Posted: Tue Jul 04, 2006 3:26 am Subject: db2 how to create database simultaneity ? |
| WHILE FIRST DB2 datbase create is executing,
if I create second database, report -911 error, DSNDB06 .SYSDBAUT is DB2 system table probably DB2 system table is locked bye first job |
|
| Topic: db2 how to create database simultaneity ? |
|
| abc2000 Replies: 3 Views: 2996 |
Forum: Database Posted: Tue Jul 04, 2006 3:24 am Subject: db2 how to create database simultaneity ? |
| WHILE FIRST DB2 datbase create is executing,
if I create second database, report -911 error, probly DSNDB06 .SYSDBAUT is DB2 system table probably DB2 system table is locked bye first job |
|
| Topic: db2 how to create database simultaneity ? |
|
| abc2000 Replies: 3 Views: 2996 |
Forum: Database Posted: Mon Jul 03, 2006 8:19 am Subject: db2 how to create database simultaneity ? |
| db2 how to create database simultaneity ?
I need create a lot of db2 database, if I create database simultaneity, I get a -911 error DSNT408I SQLCODE = -911, ERROR: THE CURRENT UNIT ... |
|
| Topic: REXX 'say' connot output some characters such as '{' '}' |
|
| abc2000 Replies: 1 Views: 1065 |
Forum: TSO and ISPF Posted: Tue Jun 27, 2006 1:02 am Subject: REXX 'say' connot output some characters such as '{' '}' |
| Z/OS REXX 'say' connot output some characters such as '{' '}' , but EXECIO output normally
say "{ $ } [ ] " : : : : : How to output these character using 's ... |
|
| Topic: DB2 4074 4056 Calculating the space required for a table |
|
| abc2000 Replies: 1 Views: 1467 |
Forum: Database Posted: Sat Jun 03, 2006 2:45 am Subject: DB2 4074 4056 Calculating the space required for a table |
| DB2 4074 4056
Calculating the space required for a table the space available to store records in a 4 KB page is 4074 bytes. Achieving that maximum in practice is not always simple. For examp ... |
|
| Topic: need EDIT Macro to replace with newline |
|
| abc2000 Replies: 1 Views: 1470 |
Forum: TSO and ISPF Posted: Thu May 11, 2006 5:21 am Subject: need EDIT Macro to replace with newline |
| need EDIT Macro replace with newline
IN Ultraedit, searching and replacing newline (Carriage Return/Line Feed) characters may be searched for or replaced. To specify the newline characters, ... |
|
| Topic: Recovering a partitioned tablespace |
|
| abc2000 Replies: 3 Views: 1976 |
Forum: Database Posted: Fri Apr 21, 2006 4:15 am Subject: Recovering a partitioned tablespace |
| you need write 31 lines RECOVER statement,
one for one data sets |
|
| Topic: How to run SPUFI in batch setup |
|
| abc2000 Replies: 4 Views: 3986 |
Forum: Database Posted: Sun Apr 16, 2006 9:56 pm Subject: How to run SPUFI in batch setup |
| I always run a lot of SQL for long time, if I use spufi in online, in the long time,
I can not do anything if I use dsntep2, when it errors, it can not roolback, I must change the erros and di ... |
|
| Topic: How to run SPUFI in batch setup |
|
| abc2000 Replies: 4 Views: 3986 |
Forum: Database Posted: Fri Apr 14, 2006 7:09 am Subject: How to run SPUFI in batch setup |
| difference beetween DB2 SPUFI vs DSNTEP2
1. if error DB2 SPUFI can rollback, but DSNTEP2 can not rollback，this would cause data integrity problem, it is very important 2. DS ... |
|
| Topic: Does a SQL statmement output a row in Multiple line ? |
|
| abc2000 Replies: 3 Views: 1837 |
Forum: Database Posted: Wed Apr 12, 2006 9:35 pm Subject: Does a SQL statmement output a row in Multiple line ? |
| I want a record ouput in contiguous lines, like my example above,
but DSNTEP2 does not if a field length exceed 133 char, DSNTEP2 will truncate it to 133 chars Can you tell me some about t ... |
|
| Topic: How to run SPUFI in batch setup |
|
| abc2000 Replies: 4 Views: 3986 |
Forum: Database Posted: Wed Apr 12, 2006 9:03 pm Subject: How to run SPUFI in batch setup |
| How to run SPUFI in batch setup
I have seen "How to run SPUFI in batch" http://groups.google.com/group/bit.listserv.db2-l/browse_thread/thread/5ea4629d20bee493/5b9806f06c07f6ae%235b9 ... |
|
| Topic: Does a SQL statmement output a row in Multiple line ? |
|
| abc2000 Replies: 3 Views: 1837 |
Forum: Database Posted: Tue Apr 11, 2006 10:24 pm Subject: Does a SQL statmement output a row in Multiple line ? |
| Using SPUFI or DSNTIAUL , Does a SQL statmement output a row in Multiple line ?
IN SYBASE, we can use char(13) produce newline, for example select name ,char(13), dbid from sysdatabases ... |
|
| Topic: A question about DB2 Automation Tool(HAA) Dataset Manager |
|
| abc2000 Replies: 2 Views: 1887 |
Forum: Database Posted: Tue Apr 11, 2006 8:52 pm Subject: A question about DB2 Automation Tool(HAA) Dataset Manager |
| Thank you, kolusu!
I have seen all of this book, but it give a JCL example that moves four data sets, not I want I want to save the The DSM Tablespaces screen lists to a data sets |
|
| Topic: A question about DB2 Automation Tool(HAA) Dataset Manager |
|
| abc2000 Replies: 2 Views: 1887 |
Forum: Database Posted: Tue Apr 11, 2006 12:58 am Subject: A question about DB2 Automation Tool(HAA) Dataset Manager |
| A question about DB2 Automation Tool(HAA) Dataset Manager
Using Dataset Manager's online interface, We can see Tablespaces' information Who Used Dataset Manager in batch, I want save ... |
|
All times are GMT - 5 Hours |