See if it works for a current database, new tablespace. For example, if you have dsnd10.dsndbd.XXXXX.tspacea try to create tablespacb in database XXXXX. This is looking more and more like acs routines
Gregg Ferris | Systems Engineer IV (Contractor) Kentucky Farm Bureau Insurance Office: (502) 495-5000 x35273 |Cell: (502) 797-5595 -----Original Message----- From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Binyamin Dissen Sent: Wednesday, April 30, 2025 6:11 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SMS dataclas WRITE allocating DB2 tablespace No, it is a new database. On Tue, 29 Apr 2025 19:53:34 +0000 "Ferris, Gregg" <000007a4b6ce0230-dmarc-requ...@listserv.ua.edu> wrote: :>Do you have any DSND10.DSNDBD.DBNAME.** files where DBNAME is the same value as the database in your IN DATABASE clause? If so, then that would seem to remove your ACS routines (unless they have been changed recently) :> :>Any way to check the ACS is find select a currently existing file and try to create a new one in that database, :> :>Eg. :> :>If you have DSND10.DSNDBD.DATABASA.TSPACEA.** :> :>Try a create tablespace TSPACEB in database DATABASA and see if that is allocated. :> :> :> :> :> :>Gregg Ferris | Systems Engineer IV (Contractor) :> :>Kentucky Farm Bureau Insurance :>Office: (502) 495-5000 x35273 :>|Cell: (502) 797-5595 :>-----Original Message----- :>From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Binyamin Dissen :>Sent: Tuesday, April 29, 2025 2:47 PM :>To: IBM-MAIN@LISTSERV.UA.EDU :>Subject: Re: SMS dataclas WRITE allocating DB2 tablespace :> :>All VS :> :>On Tue, 29 Apr 2025 16:33:11 +0000 "Ferris, Gregg" :><000007a4b6ce0230-dmarc-requ...@listserv.ua.edu> wrote: :> :>:>Thanks. what does the dsorg show for the other dsnd10.dsndbd.** files? :>:> :>:> :>:> :>:>Gregg Ferris | Systems Engineer IV (Contractor) :> :>Kentucky Farm Bureau Insurance :>:>Office: (502) 495-5000 x35273 :>:>|Cell: (502) 797-5595 :>:>-----Original Message----- :>:>From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Binyamin Dissen :>:>Sent: Tuesday, April 29, 2025 12:23 PM :>:>To: IBM-MAIN@LISTSERV.UA.EDU :>:>Subject: Re: SMS dataclas WRITE allocating DB2 tablespace :> :>:>CREATE TABLESPACE name IN database :>:> SEGSIZE 4 NUMPARTS 5 :>:> USING STOGROUP SYSDEFLT PRIQTY 48 SECQTY -1 :>:> BUFFERPOOL BP1 :>:> :>:>On Tue, 29 Apr 2025 15:20:23 +0000 "Ferris, Gregg" :>:><000007a4b6ce0230-dmarc-requ...@listserv.ua.edu> wrote: :>:> :>:>:>It seems like your ACS routine is restricting the new vsam file to non-sms, but one or more of your parms in the create tablespace ddl is providing extended format info, e.g. size :> :>Are you able to paste the entire create TS ddl in the chat? :>:>:> :>:>:> :>:>:> :>:>:> :>:>:>Gregg Ferris | Systems Engineer IV (Contractor) :> :>Kentucky Farm Bureau Insurance :>:>:>Office: (502) 495-5000 x35273 :>:>:>|Cell: (502) 797-5595 :>:>:>-----Original Message----- :>:>:>From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Ferris, Gregg :>:>:>Sent: Tuesday, April 29, 2025 11:12 AM :>:>:>To: IBM-MAIN@LISTSERV.UA.EDU :>:>:>Subject: Re: SMS dataclas WRITE allocating DB2 tablespace :> :>If you do an ispf 3.4 on :> :>:>:>DSND10.DSNDBD.** :>:>:> :>:>:>Then scroll right on the results, what do you see for the DSORG? :>:>:> :>:>:> :>:>:>Gregg Ferris | Systems Engineer IV (Contractor) :> :>Kentucky Farm Bureau Insurance :>:>:>Office: (502) 495-5000 x35273 :>:>:>|Cell: (502) 797-5595 :>:>:>-----Original Message----- :>:>:>From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Binyamin Dissen :>:>:>Sent: Tuesday, April 29, 2025 10:31 AM :>:>:>To: IBM-MAIN@LISTSERV.UA.EDU :>:>:>Subject: Re: SMS dataclas WRITE allocating DB2 tablespace :> :>The DSNP message was on the console. :>:>:> :>:>:>I check the FILTLIST for my stuff first, and ACS test confirm that it works. :>:>:> :>:>:>Doing an ISPF 3.2 allocation drives it. :>:>:> :>:>:>Should I be able to see the WRITEs under DB2? How can I see their DEFINE CLUSTER command? :>:>:> :>:>:> :>:>:> :>:>:>On Tue, 29 Apr 2025 13:32:20 +0000 "Ferris, Gregg" :>:>:><000007a4b6ce0230-dmarc-requ...@listserv.ua.edu> wrote: :>:>:> :>:>:>:>So you likely have many datasets that begin DSND10.DSNDB. Can you verify that? Also, in the zos syslog, do you have any other messages for that same time frame? :>:>:>:> :>:>:>:> :>:>:>:> :>:>:>:> :>:>:>:> :>:>:>:> :>:>:>:>Gregg Ferris | Systems Engineer IV (Contractor) :> :>Kentucky Farm Bureau Insurance :>:>:>:>Office: (502) 495-5000 x35273 :>:>:>:>|Cell: (502) 797-5595 :>:>:>:>-----Original Message----- :>:>:>:>From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Binyamin Dissen :>:>:>:>Sent: Tuesday, April 29, 2025 9:23 AM :>:>:>:>To: IBM-MAIN@LISTSERV.UA.EDU :>:>:>:>Subject: Re: SMS dataclas WRITE allocating DB2 tablespace :> :>:>:>:>SYSDEFLT=DSND10 :>:>:>:> :>:>:>:> :>:>:>:> :>:>:>:>On Tue, 29 Apr 2025 12:48:52 +0000 "Ferris, Gregg" :>:>:>:><000007a4b6ce0230-dmarc-requ...@listserv.ua.edu> wrote: :>:>:>:> :>:>:>:>:>What is the vcat hlq value for the stogroup in the create ts ddl? :>:>:>:>:> :>:>:>:>:> :>:>:>:>:>Gregg Ferris | Systems Engineer IV (Contractor) :> :>Kentucky Farm Bureau Insurance :>:>:>:>:>Office: (502) 495-5000 x35273 :>:>:>:>:>|Cell: (502) 797-5595 :>:>:>:>:>-----Original Message----- :>:>:>:>:>From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Binyamin Dissen :>:>:>:>:>Sent: Tuesday, April 29, 2025 8:39 AM :>:>:>:>:>To: IBM-MAIN@LISTSERV.UA.EDU :>:>:>:>:>Subject: SMS dataclas WRITE allocating DB2 tablespace :> :>The CREATE TABLESPACE is getting :> :>DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED :>:>:>:>:> BY AN UNAVAILABLE RESOURCE. REASON 00D70025, TYPE OF :>:>:>:>:> RESOURCE 00000220, AND RESOURCE NAME :>:>:>:>:> dsname :>:>:>:>:> :>:>:>:>:>DSNP009I -DBDG THE FOLLOWING ERROR MESSAGES WERE 999 RECEIVED FOR DEFINE CLUSTER ON :>:>:>:>:>dsname1 :>:>:>:>:>IDC3014I CATALOG ERROR :>:>:>:>:>IDC3009I ** VSAM CATALOG RETURN CODE IS 48 - REASON CODE IS :>:>:>:>:>IGG0CLAT-80 :>:>:>:>:>IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12 :> :>I put a lot of WRITEs in the dataclass exit but nothing is coming out. -- Binyamin Dissen <bdis...@dissensoftware.com> https://urldefense.com/v3/__http://www.dissensoftware.com__;!!GngZujM!NR1jUGhnwSMrygYtSb0YweKGluDPi0zK7BfjfVq2hGnJ5BUOEnFnm8EePhktgqchQhpfgAMpJ52Mm8IKIh_AC6Dp-BVi2ck1Iarc$ [dissensoftware[.]com] Director, Dissen Software, Bar & Grill - Israel ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
