Cliff,
To add to this, the JDBC drivers for DB2 under z/VM are not being
upgraded, either. This causes a problem with some 3rd party software
connecting to the database.
Nora Graves
nora.e.gra...@irs.gov
Main IRS, Room 6531
(202) 622-6735
Fax (202) 622-3123
SE:W:CAR:MP:D:KS:BRSI
-Original
I do not believe that this is the problem. I was giving you information
on the failing job that I am most familiar with. Other jobs that fail
are submitted to VMBatch by the ID that also owns the SFS directories.
FYI, "VMBatch" is the IBM VM Batch Facility Version 2.2, I was not
aware until rec
Jim,
There are basically no messages at all in the console for the SFS
service machine. One of the failures was on April 13. This is the
console for that day--no editing at all of the contents.
HCPMID6001I TIME IS 00:00:00 EDT WEDNESDAY 04/13/11
Jim,
I didn't think to look there, I will.
Our regular backups are VMBACKUP, which is scheduled to run 90 minutes
after this job runs. This job runs only 2 minutes maximum, so I know
that isn't the problem. But the SFS console may have some good
indications. I'll see what I can find there.
Th
s the owner of most of the directories" You mean:
the submitter is userid ABC, the dirids are all named
"fpoolid:ABC.something"?
2011/4/14 Graves Nora E
We are having an intermittent problem with SFS and I'm hoping
someone may have some ideas of what to pursue next.
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: SFS problem
On Thursday, 04/14/2011 at 03:47 EDT, Graves Nora E
wrote:
> DMSOPN1258E You are not authorized to write to file XX 20110413
Z1
:
> I've issued QUERY ACCESSED. The directory shows that is accessed
R/W.
>
> When the
checking out SafeSFS from safesfs.com. We're
vary
satisfied customers, it makes authorizations much MUCH simpler, saves
huge
amounts of effort and back time.
Mike Walter
Aon Corporation
The opinions expressed herein are mine alone, not my employer's.
"Graves Nora E"
Sent
We are having an intermittent problem with SFS and I'm hoping someone
may have some ideas of what to pursue next.
We have several batch jobs that run under VMBATCH overnight. Sometimes
they are not able to create a file in a directory, even though most
times it is successful. The only differenc
The Database Administration Guide explains the Stored Procedure servers.
It's Chapter 11 in the 7.5 manual.
The SQL Reference can tell you how to create a stored procedure server
for your database. See the CREATE PSERVER statement.
I hope this helps,
Nora Graves
nora.e.gra...@irs.gov
Main IRS,
I really like the ability to search every book on the bookshelf for the
occurrence of what I'm looking up. I've been known to search the older
versions first if the latest versions are only available in PDF (DB2 for
z/VM books in particular). Once I narrow down the search, then I'll go
to the lat
@LISTSERV.UARK.EDU
Subject: Re: DB2 stats
Hi, Nora.
These guys might be able to help:
http://www.sprdb2.com/
Have a good one.
On 06/30/2010 08:31 AM, Graves Nora E wrote:
> We're running DB2 for z/VM release 7.5, under z/VM 5.4. We have a
> request for database transaction statisti
We're running DB2 for z/VM release 7.5, under z/VM 5.4. We have a
request for database transaction statistics from the planning group.
Does anyone know if these are available, and, if so, where they can be
found?
TIA,
Nora Graves
nora.e.gra...@irs.gov
Main IRS, Room 6531
(202) 622-6735
Fax (2
uestion
Unfortunately no monitor. Not since CA pulled the rug out from under the
DBMonitor product Sterling had.
Thank you Nora.
Bill
-Original Message-
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Graves Nora E
Sent: Thursday, January 28, 2010 6:46 AM
To
Do you run a User Locking monitor? If so, you can view the report at
any time from the Control Center Monitor List function. That will show
you the number of User and System blocks allocated and used.
I do not see any references to this condition either.
Nora Graves
nora.e.gra...@irs.gov
Main
r, it will tell CP
to get rid of some of its pages.
2009/9/1 Graves Nora E
Cross-posted to VM/ESA and DB2 lists.
I'm running DB2 7.5 under z/VM 5.4 (both are the current
releases). We have a brand-new z10 processor. My Systems Programmer
has offered me 1 Gig of RA
Cross-posted to VM/ESA and DB2 lists.
I'm running DB2 7.5 under z/VM 5.4 (both are the current releases). We
have a brand-new z10 processor. My Systems Programmer has offered me 1
Gig of RAM, up from our current Virtual Storage of 384 Meg for the
production database.
I'd like to take advant
-
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Tom Duerbusch
Sent: Tuesday, June 16, 2009 2:14 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: DB2 Problem
ERSHIST_X is a view of table CDERS_HISTORY.
Tom Duerbusch
THD Consulting
>>> Graves Nora E 6/
Well, I'm hoping you were updating the table names for security
purposes, and that's the error below. In this example, the table you're
using for the SELECT (ASN.ERSHIST_X) is not the same table that you
specify in the DELETE (ASN.CDERS_HISTORY).
Nora
-Original Message-
From: The I
And it makes it easy to revoke privileges from a user: just remove the
LOGONBY authority. This is handy in an environment where roles change
frequently. And if the person leaves or retires, deleting the User ID
takes care of all access, without scrambling to remember which
seldom-used accounts th
As Zork so eloquently put it, "Talking to yourself is said to be a sign
of impending mental collapse."
I prefer to think of this as "discussing the problem with the person who
understands it the best." That's my story and I'm sticking with it.
Nora Graves
Another consideration is DB2, if you run DB2 for VM/VSE. We have
successfully written log archive files to disk, but for the full
archives apparently tape is the only thing it will accept. Product
documentation indicates that tape is required for log archives as well,
unless running a user-define
I can answer the COBOL part, anyway. :-)
He needs a resulting field that will appear this way for each example:
0 00
1 001000
12012000
123.4 123400
1234.56 0001234560
Nora Graves
[EMAIL PROTECTED]
Main I
We use LOGONBY to be able to log onto a test user whose profile has
nothing but class G authority. It's great to be able to do final
testing to make sure that the final users have access to all necessary
functions. Changing the privileges by default might negate some of
those results.
Nora Gra
You might try this:
Change it to FB instead of VBS, make it file mode D1. Look at the
listing from the original unload; use the data for the last column
unloaded to determine the correct file length.
Nora Graves
[EMAIL PROTECTED]
Main IRS, Room 6513
(202) 622-6735
_
We've been running DB/2 for VM since Release 6.1. We're currently on DB/2 7.3
under z/VM 4.4. Our current LASTING GLOBALV is 137 lines long for SQLPROD, and
it doesn't have any duplicates in it.
We do not have the SQLINIT step in our PROFILE EXEC for any of the databases.
We also do not log
25 matches
Mail list logo