DSNT408I SQLCODE = -904

JH

DSNT408I SQLCODE = -904
To List:
We kept getting -904 when creating a tablespace using
a SMS stogroup with a newly created VCAT.
I know for sure that space is not a issue, The other
possibility is ACF2, but when comparing with other
working VCAT, I could not see any difference in ACF2
rules.
Thanks for your help.
Joe

============
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL
EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D70025, TYPE
OF RESOURCE 00000220, AND
RESOURCE NAME
DBMD2T1D.DSNDBC.DBJOE001.TSJOE001.I0001.A001

DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE

DSNT415I SQLERRP = DSNXICTS SQL PROCEDURE DETECTING
ERROR
DSNT416I SQLERRD = 105 0 0 -1 0 0 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000069' X'00000000'
X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION






__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ruediger Kurtz

AW: DSNT408I SQLCODE = -904
(in response to JH)
Well Joe,
I'm afraid space is an issue. You have run out of space. How much space have you got in your
SMS-Storagegroup ?
One possible workaround could be to reduce the primary allocation and see if that fits
in your available space. Still, consider adding more volumes to oyur storage-groups.

Hth

Ruediger

-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email]Im
Auftrag von Joe Huang
Gesendet: Montag, 13. Dezember 2004 13:31
An: [login to unmask email]
Betreff: DSNT408I SQLCODE = -904


To List:
We kept getting -904 when creating a tablespace using
a SMS stogroup with a newly created VCAT.
I know for sure that space is not a issue, The other
possibility is ACF2, but when comparing with other
working VCAT, I could not see any difference in ACF2
rules.
Thanks for your help.
Joe

============
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL
EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D70025, TYPE
OF RESOURCE 00000220, AND
RESOURCE NAME
DBMD2T1D.DSNDBC.DBJOE001.TSJOE001.I0001.A001

DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE

DSNT415I SQLERRP = DSNXICTS SQL PROCEDURE DETECTING
ERROR
DSNT416I SQLERRD = 105 0 0 -1 0 0 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000069' X'00000000'
X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION






__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Richard Clark

Re: DSNT408I SQLCODE = -904
(in response to Ruediger Kurtz)
Any messages in the DBM1 log? Does DBM1 have the authority to write to these packs? Are you SMS rules defined correctly so that
these datasets will be created on the packs you expect them to be created on?

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Joe Huang
Sent: Monday, December 13, 2004 7:31 AM
To: [login to unmask email]
Subject: DSNT408I SQLCODE = -904


To List:
We kept getting -904 when creating a tablespace using
a SMS stogroup with a newly created VCAT.
I know for sure that space is not a issue, The other possibility is ACF2, but when comparing with other working VCAT, I could not
see any difference in ACF2 rules. Thanks for your help. Joe

============
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL
EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D70025, TYPE
OF RESOURCE 00000220, AND
RESOURCE NAME DBMD2T1D.DSNDBC.DBJOE001.TSJOE001.I0001.A001

DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE

DSNT415I SQLERRP = DSNXICTS SQL PROCEDURE DETECTING
ERROR
DSNT416I SQLERRD = 105 0 0 -1 0 0 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000069' X'00000000'
X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION






__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be
reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

-----------------------------------------
CONFIDENTIALITY NOTE: This e-mail message, including any attachment(s),
contains information that may be confidential, protected by the attorney-
client or other legal privileges, and/or proprietary non-public
information. If you are not an intended recipient of this message or an
authorized assistant to an intended recipient, please notify the sender by
replying to this message and then delete it from your system. Use,
dissemination, distribution, or reproduction of this message and/or any of
its attachments (if any) by unintended recipients is not authorized and
may be unlawful.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Moschelli Mauro

Re: DSNT408I SQLCODE = -904
(in response to Richard Clark)
Are you creating tablespace "USING STOGROUP" or "USING VCAT"?
In the second case you must manually define the VSAM

HTH

Mauro Moschelli
SanPaoloIMI S.p.A.

-> -----Original Message-----
-> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
-> Behalf Of Joe Huang
-> Sent: Monday, December 13, 2004 1:31 PM
-> To: [login to unmask email]
-> Subject: DSNT408I SQLCODE = -904
->
->
-> To List:
-> We kept getting -904 when creating a tablespace using
-> a SMS stogroup with a newly created VCAT.
-> I know for sure that space is not a issue, The other
-> possibility is ACF2, but when comparing with other
-> working VCAT, I could not see any difference in ACF2
-> rules.
-> Thanks for your help.
-> Joe
->
-> ============
-> DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL
-> EXECUTION CAUSED BY AN
-> UNAVAILABLE RESOURCE. REASON 00D70025, TYPE
-> OF RESOURCE 00000220, AND
-> RESOURCE NAME
-> DBMD2T1D.DSNDBC.DBJOE001.TSJOE001.I0001.A001
->
-> DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
->
-> DSNT415I SQLERRP = DSNXICTS SQL PROCEDURE DETECTING
-> ERROR
-> DSNT416I SQLERRD = 105 0 0 -1 0 0 SQL
-> DIAGNOSTIC INFORMATION
-> DSNT416I SQLERRD = X'00000069' X'00000000'
-> X'00000000' X'FFFFFFFF'
-> X'00000000' X'00000000' SQL DIAGNOSTIC
-> INFORMATION
->
->
->
->
->
->
-> __________________________________
-> Do you Yahoo!?
-> Yahoo! Mail - 250MB free storage. Do more. Manage less.
-> http://info.mail.yahoo.com/mail_250
->
-> -------------------------------------------------------------
-> --------------------
-> Welcome to the IDUG DB2-L list. To unsubscribe, go to the
-> archives and home page at
-> http://www.idugdb2-l.org/archives/db2-l.html. From that page
-> select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Il contenuto e gli allegati di questo messaggio sono strettamente
confidenziali, e ne sono vietati la diffusione e l'uso non autorizzato.

Le opinioni ivi eventualmente espresse sono quelle dell'autore: di
conseguenza il messaggio non costituisce impegno contrattuale tra
Sanpaolo IMI ed il destinatario, e la banca non assume alcuna
responsabilita' riguardo ai contenuti del testo e dei relativi allegati,
ne' per eventuali intercettazioni, modifiche o danneggiamenti.

Qualora il presente messaggio Le fosse pervenuto per errore, Le saremmo
grati se lo distruggesse e, via e-mail, ce ne comunicasse l' errata
ricezione all'indirizzo [login to unmask email]


This e-mail (and any attachment(s)) is strictly confidential and for use
only by intended recipient(s). Any opinions therein expressed are those
of the author. Therefore its content doesn't represent any commitment
between Sanpaolo IMI and the recipient(s) and no liability or
responsibility is accepted by Sanpaolo IMI for the above mentioned
content.

Sanpaolo IMI S.p.A. is a Bank authorised by Banca d'Italia; Sanpaolo IMI
S.p.A., London Branch, is regulated by the Financial Services Authority
for the conduct of investment business in the UK.

If you are not an intended recipient(s), please notify
[login to unmask email] promptly and destroy this message.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tina Hilton

Re: DSNT408I SQLCODE = -904
(in response to Moschelli Mauro)
Did you follow the instructions for the 00D70025 reason code and look for
messages DSNP009I and DSNP010I? What do they show? The syslog and/or DB2
address spaces should list additional messages that you need to look at.

Tina Hilton

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of
Joe Huang
Sent: Monday, December 13, 2004 7:31 AM
To: [login to unmask email]
Subject: DSNT408I SQLCODE = -904

To List:
We kept getting -904 when creating a tablespace using
a SMS stogroup with a newly created VCAT.
I know for sure that space is not a issue, The other
possibility is ACF2, but when comparing with other
working VCAT, I could not see any difference in ACF2
rules.
Thanks for your help.
Joe

============
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL
EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D70025, TYPE
OF RESOURCE 00000220, AND
RESOURCE NAME
DBMD2T1D.DSNDBC.DBJOE001.TSJOE001.I0001.A001

DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE

DSNT415I SQLERRP = DSNXICTS SQL PROCEDURE DETECTING
ERROR
DSNT416I SQLERRD = 105 0 0 -1 0 0 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000069' X'00000000'
X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION






__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

-----------------------------------------------------------------------------
----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

JH

Re: DSNT408I SQLCODE = -904
(in response to Tina Hilton)
Ooops, I forgot to notify the SMS administrator to
add the new VCAT to the SMS.
Thanks !!
Joe

--- "Clark, Richard" <[login to unmask email]> wrote:

> Any messages in the DBM1 log? Does DBM1 have the
> authority to write to these packs? Are you SMS rules
> defined correctly so that
> these datasets will be created on the packs you
> expect them to be created on?
>
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On Behalf Of Joe Huang
> Sent: Monday, December 13, 2004 7:31 AM
> To: [login to unmask email]
> Subject: DSNT408I SQLCODE = -904
>
>
> To List:
> We kept getting -904 when creating a tablespace
> using
> a SMS stogroup with a newly created VCAT.
> I know for sure that space is not a issue, The other
> possibility is ACF2, but when comparing with other
> working VCAT, I could not
> see any difference in ACF2 rules. Thanks for your
> help. Joe
>
> ============
> DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL
> EXECUTION CAUSED BY AN
> UNAVAILABLE RESOURCE. REASON 00D70025, TYPE
> OF RESOURCE 00000220, AND
> RESOURCE NAME
> DBMD2T1D.DSNDBC.DBJOE001.TSJOE001.I0001.A001
>
> DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
>
> DSNT415I SQLERRP = DSNXICTS SQL PROCEDURE
> DETECTING
> ERROR
> DSNT416I SQLERRD = 105 0 0 -1 0 0 SQL
> DIAGNOSTIC INFORMATION
> DSNT416I SQLERRD = X'00000069' X'00000000'
> X'00000000' X'FFFFFFFF'
> X'00000000' X'00000000' SQL DIAGNOSTIC
> INFORMATION
>
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - 250MB free storage. Do more. Manage
> less. http://info.mail.yahoo.com/mail_250
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go
> to the archives and home page at
> http://www.idugdb2-l.org/archives/db2-l.html.
> From that page select "Join or Leave the list". The
> IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The
> IDUG List Admins can be
> reached at [login to unmask email] Find out
> the latest on IDUG conferences at
> http://conferences.idug.org/index.cfm
>
> -----------------------------------------
> CONFIDENTIALITY NOTE: This e-mail message,
> including any attachment(s),
> contains information that may be confidential,
> protected by the attorney-
> client or other legal privileges, and/or
> proprietary non-public
> information. If you are not an intended recipient
> of this message or an
> authorized assistant to an intended recipient,
> please notify the sender by
> replying to this message and then delete it from
> your system. Use,
> dissemination, distribution, or reproduction of
> this message and/or any of
> its attachments (if any) by unintended recipients
> is not authorized and
> may be unlawful.
>
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go
> to the archives and home page at
> http://www.idugdb2-l.org/archives/db2-l.html. From
> that page select "Join or Leave the list". The IDUG
> DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG
> List Admins can be reached at
> [login to unmask email] Find out the latest
> on IDUG conferences at
> http://conferences.idug.org/index.cfm
>





__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm