tag:blogger.com,1999:blog-18371456.post114384184044372311..comments2024-03-26T00:07:20.400-05:00Comments on The Db2 Portal Blog: DSNTIAD - The Dynamic SQL Update ProgramCraig S. Mullinshttp://www.blogger.com/profile/17077237739217901780noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-18371456.post-54478962475850519882014-12-16T16:33:33.069-06:002014-12-16T16:33:33.069-06:00Korrapati...
Re-read the blog post. DSNTIAD "...Korrapati...<br /><br />Re-read the blog post. DSNTIAD "can issue the same DB2 dynamic SQL statements as DSNTEP2, with the exception of the SELECT statement." You are trying to use it to run a SELECT. What you want to use is DSNTEP2 (see http://db2portal.blogspot.com/2006/03/dsntep2-aka-batch-spufi.html)<br /><br />Regards,<br />CraigCraig S. Mullinshttps://www.blogger.com/profile/17077237739217901780noreply@blogger.comtag:blogger.com,1999:blog-18371456.post-37025027201939282822014-12-16T05:11:53.696-06:002014-12-16T05:11:53.696-06:00Hi Criag,
As part making some automation by using...Hi Criag,<br /><br />As part making some automation by using REXX to convert all Tables spaces which are reaching 50gb,im using one sql SELECT statement to generate all TS's who reached 50 gb by using DSNTIAD and getting error below <br />SELECT V1.DBNAME, V1.NAME, V1.TOTAL_SPACE <br />FROM (SELECT A.DBNAME, A.NAME, SUM(A.SPACE) AS TOTAL_SPACE <br />FROM SYSIBM.SYSTABLESPACESTATS A, SYSIBM.SYSTABLESPACE B <br />WHERE A.DBNAME = B.DBNAME <br />AND A.NAME = B.NAME <br />AND B.TYPE = ' ' <br />AND B.NTABLES = 1 <br />GROUP BY A.DBNAME, A.NAME <br />ORDER BY 3 DESC) V1 <br />WHERE V1.TOTAL_SPACE > 20428800 <br /><br /> SQL ERROR DURING EXECUTE IMMEDIATE <br />DSNT408I SQLCODE = -518, ERROR: THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID<br />DSNT418I SQLSTATE = 07003 SQLSTATE RETURN CODE <br />DSNT415I SQLERRP = DSNXEDS1 SQL PROCEDURE DETECTING ERROR <br />DSNT416I SQLERRD = -515 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION <br />DSNT416I SQLERRD = X'FFFFFDFD' X'00000000' X'00000000' X'FFFFFFFF' X'0000<br /> INFORMATION <br /><br /> <br /><br />//SYSTSIN DD * <br /> DSN SYSTEM(CB21) <br /> RUN PROGRAM(DSNTIAD) PLAN(DSNTIA10) - <br /> LIB('CB21.RUNLIB.LOAD') <br /> END <br /><br />Could you please help me here how to run this select query...Here im trying to put select output into dataset using SYSPRINT..korrapatihttps://www.blogger.com/profile/13961704561179667915noreply@blogger.comtag:blogger.com,1999:blog-18371456.post-82803383165231840952014-10-24T01:56:17.207-05:002014-10-24T01:56:17.207-05:00Hi there , wonderful information
http://www.google...Hi there , wonderful information<br />http://www.google.comAnonymoushttps://www.blogger.com/profile/09288373582833041744noreply@blogger.comtag:blogger.com,1999:blog-18371456.post-46674195913348918602010-09-30T13:44:06.708-05:002010-09-30T13:44:06.708-05:00This was helpful as our company uses DSNTIAD and I...This was helpful as our company uses DSNTIAD and I was struggling with finding the issue. Turns out it was my comments.Anonymousnoreply@blogger.com