View Full Version : db2 answers

Pages : 1 2 3 4 5 6 7 [8] 9 10 11 12 13 14 15 16 17 18 19 20 21 22

  1. SQL3522N error for Load command
  2. System Error - Rebuilding tablespace (DB2 v9)
  3. DB2 Backup Creates 2 backup files
  4. Urgent! How to bind an numeric value for a Dynamic SQL Statement inside Stored Proc
  5. DIA3220W in the diaglog
  7. XML with DB2 UDB v8.2 ??????????
  8. DB2 exam 701 - Need dumps
  9. SQL Stored Procedure not accepting parameters
  10. logging output
  11. Get Last Inserted IDENTITY
  12. error on jdbc type 2 connection with native implementation
  13. SQLJ - java.sql.SQLException: profile DimoiPolyInsert_SJProfile0 not found
  14. jdbc username and password follow-up
  15. join in DB2 forum
  16. explain - invalid token
  17. Installing DB2 ESE 8.2
  18. db2wdog
  19. Does db2 agents only get what it need?
  20. IBM 595 dual core CPU DB partitioning question
  21. get application handle
  22. Anybody had a problem with db2exfmt
  23. DB2 WebApp SQL-Client
  24. xml with db2 v8.2?
  25. jdbc on db2: getMetadate().getColumns() returns empty resultset
  26. jdbc connection without giving username and password
  27. EOF not working
  28. Sort heap threshold configuration parameter for 32bits DB2
  29. DB2 SQL and Members
  30. Moving a DB/2 instance
  31. Deadlock even with SELECT..FOR UPDATE
  32. jdbc calling stored procedure
  33. Automated db2 commands in a shell script
  34. db2 isolation level
  35. db2 on zlinux - DAS problem
  36. Different handlers in db2 stored procedure...
  37. What's the escape char in DB2 SQL
  38. DB2 Configuration
  39. DB2 connect
  40. '' and NULL confusion
  41. Data type: FOR BIT DATA?
  42. how to remove everything related to a user(schema)
  43. db2
  44. Custom error messages in db2
  45. linking other servers with db2 on local as well as other machine in network
  46. linking sql server to db2 on the same machine
  47. isql and xp_cmdshell equvalent of sql server in dB2
  48. Mystery SELECT Statement
  49. Errror Declaring Local Variable in the trigger body on db2 udb v8 on z/0s
  50. Information Integrator
  51. Moving STMMLOG to another location
  52. print values
  53. DB2 equivalent For Oracle first_value/last_value functions
  54. Converting IDMS db to DB2
  55. db2fs failed to start
  56. Anybody hit SQL0407N bug ?
  57. db2 view with virtual column
  58. Reorg , Runstat and Stored Proc
  59. Export command in db2
  60. Back-up image is not visible when restoring database
  61. How to Create Shadow ODBC connectivity for DB2 for ETLs
  62. Catalog table for Tablespace size information
  63. Migration from Net.Data
  64. Error after resetting the db2admin password
  65. Trigger help
  66. IBM DB2 9 support in oXygen XML editor
  67. IBM DB2 password issue
  68. Rollback with atomic block
  69. consolidate time periods
  70. The Declare cursor SQL construct or statement is not supported.
  71. DB2 Control Center Issue
  72. Help
  73. How Can I Stop DB2 V7 Traffic from entering my database?
  74. Question about external backups to filesystems
  75. curval in db2
  76. Invoking Cobol stored procedure using Java
  77. ** One Million FR.EE Visitors **
  78. Db2
  79. ken
  80. DB2PE with Windows and Linux
  81. SQL0437W reason code 3, anything to worry about?
  82. Commit the applied FixPak??
  83. alter column(from null to not null) in DB2 v8.x.x
  84. changing termination character
  85. Not Able to create Data Source in Db2 Alphablox
  86. Excellent Software Testing Tools Resource
  87. isql na xp_cmdshell equivalent of sql-server in db2 V8.2
  88. manual rebalancing
  89. Can I Use extern keyword in sqc
  90. Delete performance problem in V9 FP2 for a parent/child? Works in V8 FP14
  91. running table snapshot as regular login
  92. SELECT ... FOR UPDATE not locking rows
  93. help with logic
  94. How can I precomfile .sqc including header file
  95. error while accessing Task Center
  96. db2hmon failing with "Too many open files"
  97. Error When accessing Task Center
  98. Create DB2 LOGS
  99. DB2 Audit facility
  100. DB2 Logging
  101. Error: SQL1092N "User" does not have the authority to perform the requested...
  102. db2 prep hangs
  103. registering new XSR object
  104. Restore online backup and roll forward just the logs stored in it.How?
  105. Keeping MQT in-sync
  106. Size of a perticular table in DB2 database
  107. Faster Approach to delete records......
  108. seek tips on query
  109. DB2 equivalent INFORMIX.EXTEND
  110. "SQL0901N The SQL statement failed because of a non-severe error . " after degrade
  111. "SQL0901N The SQL statement failed because of a non-severe error " after degrade
  112. dascrt errors
  113. How to create a federation server to db2/400 in a db2 udb AIX databases
  114. SSIS and DB2 v9
  115. db2tapemgr problem
  116. memory allocation error executing table function
  117. Q Replication trouble
  118. Timing out while fetching data from DB2
  119. inter-partition? intra-partition?
  120. DB2 v9 Win x64 crash
  121. a good text
  123. HADR and Databases with default db container paths
  124. Not able to close cursors.
  125. Data type and host variable
  126. DB2 for z/OS Buffer Pool tuning tool - Recomendations/Experiences
  127. Problem with Java UDFs failing after a few hundred calls
  128. UDFs for hashing
  129. DST - did not bounce my DB2 server
  130. Delete explain plan question - DB2 V8 and V9
  131. Error SQL0433N - Value is too long UDF issue
  132. DB2 database integrity check?
  133. select from final table and sqlj
  134. Direct I/O and NFS
  135. ERROR: Overflow has occurred; evaluation is terminated
  136. Where does db2cc pull the java version from?
  137. MCSD-An Excellent Resource
  138. How to create a GROUP BY for use with ip address range?
  139. Sequence alteration in db2
  140. Lpad Equivalent Of Oracle In Db2
  141. Connection from Java appliaction to DB2
  142. Nested Stored Procedure returning result sets in DB2 on AS/400
  143. Uses need to be administrators with Windows Server 2003
  144. Exception Table
  145. "Application must execute a rollback."
  146. how do you write a parallel DML in AS400 database
  147. Retaining Stored Procedure Permissions
  148. Regarding the Stored procedure with comma separated input
  149. Regarding a Stored Procedure with comma separated Value in input
  150. How to handle Exception
  151. A query related to fetch(DB2)
  152. identity_val_local() returns null in V8.1
  153. DB2 error DSNT408I SQLCODE = -812 collection Id missing
  154. Retrieving identity value
  155. alter table
  156. DB2 - Output results to a file
  157. writing compound/complex sql
  158. Low cluster ratio - row compression - reorg - V9.1 question.
  159. Low cluster ratio - row compression - V9.1
  160. autostart YES or TRUE
  161. Recovering from a DB2 Crash
  162. SQL Query from iSeries Data Transfer
  163. db2-exam 700 - Sample questions
  164. db2 restore error
  165. Stored Procedures
  166. Question for DB2 703 exam.
  167. How to stop execution(infinite loop) of SP
  168. Command to retrieve all SP names fro mCLLP
  169. maintaining sequence no of rows.
  170. syntax error when creating text index
  171. Order by not working on select into GTT
  172. Update row -- autogenerate unique value without trigger??
  173. ratio of synchronous reads for bufferpool
  174. VALUES statement
  175. unixODBC
  176. ** One Million FR.EE Visitors **
  177. SQA & Testing
  178. NOT foreign key in UDB V8.2 LINUX
  179. MS Visual Studio & DB2 UDB for Windows
  180. FDR/Upstream for backup and recovery strategy for DB2 UDB on Aix
  182. DB2 Linux settings (cache/buffers/IO)
  183. Need Help on a query
  184. Problems with SQL triggers on the ISerier
  185. Deleting a column data from table
  186. Result Sets Mismatch?
  187. System Catalog Table Maintenance
  188. Reorg
  189. DB2 Maintenance Plan
  190. Java and procedures
  191. Error using Dataadapter.Fill when getting a big amount of Data
  192. conversion of comp-1 to decimal format
  193. 'Delete' keyword not working in .sqc file of my application
  194. 'Delete' keyword not working in .sqc file of my application
  195. recover selected table
  196. common table expression vs. nested table expression
  197. SECADM Authority Question
  198. V9 Load from Cursor and multiple DB's
  199. One message displayed in db2diag.log over and over
  200. SQL10003C
  201. Automatically delete old backup dumps
  202. remote server os and db2level info
  203. DB2 Error
  204. Tree Strucured data in Db2
  205. db2 dba position
  206. Error In SQL Statement
  207. storage manager tool in db2cc
  208. Stored procedure in db2 which accepts any number of Arguments
  209. Error In SQL Statement
  210. How to avoid Lock escalation
  211. Getting DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002 exception
  212. Backup Pending
  213. Software Testing Update
  214. Call stored proc from sql statement as subquery
  215. sql code = -804 query too long
  216. Using a column value as a table name in a query
  217. DB2/Unix old hand needs DB2/Windows help
  218. User identity
  219. AIX concurrent IO == Linux Asynchronous I/O
  220. 9.2 license issue
  221. Slow connection on aix 5.3
  222. clusterratio
  223. How to change cpu num on DB2 9 ESE
  224. DB2 performance on a V7.1 on Z/OS - long post
  225. Autoincrement DB2 JBOSS EJB CMP
  226. is there any genius to solve sqlcode 58005
  227. coding the control card
  228. small OLAP cube vs large OLAP cube
  229. Convert to XML Storage V9.1
  230. SQL Solution Needed
  231. DMS tbspace on Auto.Storage enabled db
  232. Variable in DB2
  233. Replication between DB2 z/OS v7 and DB2 Unix V8.2
  234. Db2 Syntax Of Group By.......URGENT
  235. DB2 sessions--its urgent
  237. DB2 Net Search Extender 9 with DB2 v8.2?
  239. Servlet to DB2 connection
  240. DDL of a table
  241. Recover tablespace in partitioned environment
  242. Large Record Identifiers (RIDs) for DB2 V9.1
  243. Recovering tables from .DAT file
  244. How can I connect to SAMPLE database?
  245. UPDATE from COUNT(*) of another table in DB2 - HOW?
  246. Migration from Oracle
  247. output query to csv or xml format
  248. DB2 instance goes down every one hour - A serious error in production server
  249. Private memory error in db2diag.log for DB2 v9
  250. Software Testing Resource
  251. # of maximum joins in DB2 7 and DB 8
  252. rearranging tables
  253. How many DB2 processes running on your Solaris server?
  254. IBM.Data.DB2.iSeries for .NET
  255. DB2 9 - depreciated registry variable - DB2LINUXAIO - WHY ?
  256. if exists in php with UDB Linux
  257. Data confilicts
  258. Calling stored proc. through Unix Shell scripts. !
  259. Can I use db2 8.1 driver(db2jcc.jar) connect to db2 7.2?
  260. Urgent Information regd. IBM Universe Basic database.
  261. need urgent info regarding rollback
  262. DB2 load with error SQL2044N Reason Code "3"
  263. Too many open files error on db2diag.log
  264. Error compiling DB2 C++ application.
  265. XBSA client/application
  266. XBSA client/application
  267. db2sqljcustomize on z/OS
  268. Identifying those tables with 'Not Logged Initially'
  269. SQL Optimizer
  270. Acucobol and DB2(udb)
  271. Mainframe - Windows codepage conversion
  272. receiving string in a stored procedure
  273. DB2 and SMS
  274. UDF call to C wrapper returning SQLUDF_VARCHAR fails
  275. RDA 6.1 compatible with DB2 9 ?
  276. Structured UDT using Java
  277. DB2 in mainframe
  278. How to relate a particular table container with the exact name of the table it contains
  279. selecting XML columns
  280. script for assigning access controls and cleanup
  281. query for VISA AVS (address verification service)
  282. DB2 storing CLOB strings in chunks of 1k
  283. Tracking Revokes
  284. SQLCODE: -805 on V8.1 fp 10
  285. What is the fastest way...
  286. Connecting to DB2 on AS400
  287. Work around for db2diag.log vulnerability?
  288. SQLDA corrupted when using VARGRAPHIC type parameters
  289. STMM 9.1warning message
  290. dynamic SQL performance
  291. How DB2 load works
  292. How DB2 load works
  293. How DB2 load works
  294. How to get port number of a db2 instance in AIX installation of DB2
  295. Need Urgent Info Regarding Retreiving Values From Child Table
  296. How to fix importing error: SQL3306N An SQL error "-289 ?
  298. Question on static package usage
  299. loading xml into db2 table
  300. New to DB2 Admin Need direction
  301. Size of stripe in Win2003 Server EE for DB2 ?
  302. recommend basic SQL book on DB2?
  303. Data Size Comparison
  304. DB2 8.2 support end-date
  305. Web Service Consumer
  306. migrate data from MySQL to DB2
  307. inline SQL PL over JDBC
  308. Merge Query Help
  309. SQL1477N Table "<table-name>" cannot be accessed
  310. Event monitor issue..
  311. scrollable resultset
  312. insert same row multiple times
  313. Backup database vs. Backup database at TS-level time differences
  314. Help Processing Integer Byte by Byte
  315. Dynamic ORDER BY clause
  316. UDF call to C wrapper for PCRE library fails - SQL0444N, Reason code: "5", SQLSTATE=42724
  317. DB2 Express-C (XP Home) - Licensing error - JDBC
  318. How to manually switch active logs
  319. Is there any way to use LIKe operator with interger values
  320. Any command for renaming a Stored Procedure?
  321. Hash/digest function
  322. DB2 UDB LUW Time stamp conversion
  323. Mixing single partition and multi partition databases in the same instance
  324. Need help with SQL query
  325. Describe non-table objects
  326. UNION statement
  327. Cannot create database
  328. Db2 on AS400 SQL loggin
  329. DB2 connection time out error
  330. DB2 Dying on OS390?
  331. Common Table Expressions (Cte) ON db2
  332. GROUP BY problem in conjunction with a SUM()
  333. db2 8.2 server install
  334. db2ckmig has no flags but db2imigr fails for db2 v9.1 migration
  335. SQL4401C : old problem, but found no working solution
  336. Getting errors when trying to build a stored procedure
  337. IF statement as SELECT's argument for a DB2 Trigger
  338. altering a table
  339. Declared Global Temporary Table in multiple Stored Procedures
  340. to Drop a unique index
  341. MQTs: Similar timeron costs, vastly different execution times
  342. New material added
  343. db2sysc consumes huge memory
  344. JDBC incorrectly retrieves date
  345. DB2 slow response on connection Win 2003
  346. DST Compliance
  347. SQL Question
  348. Indexes of tables
  349. problems creating tables inside a stored procedure
  350. SQL Package Lock
  351. Health Monitor restarted - every 14 minutes.
  352. Back Terminated to TSM - Media controller -- problem writing to vendor device. rc = -2025
  353. Is there a way to drop DB2 database buffer pool without connecting to database?
  354. Escalating locks in db2
  355. select distinct() with XML query functions.
  356. DB2 Logging and Archiving
  357. Slow prepare
  358. query browser and administrator for DB2?
  359. DST and DB2 V9 Fixpak2
  360. LDAP plugin for all LUW v. 9 editions?
  361. DB2 V8 Fixpack 15?
  362. Memory Heap Error
  363. SCOPE for REFERENCE-attributes of aggregated attributes
  364. Local copy of DB2 information center
  365. Migrating DB2 UDB ESE v8.1/8.2 from Solaris to AIX
  366. Pending Remote Request
  367. Function on IBM web page not thread-safe?
  368. DB2/AS400 and PHP
  369. Db2 Union
  370. Protocol specific error code(s): "*", "*", "0".
  371. Issue with Alphablox FastForward and relational cubes.
  372. SQL0443N The Routine "SQLSTATISTICS" returned an error
  373. Usage of Java Stored Procedure.
  374. What effects size of incremental delta backup?
  375. Renaming Sp
  376. IMS to DB2 migration
  378. Overhead executing 32-bit routines in 64-bit Instance
  379. is there a size restriction to a SQL stored proc?
  380. Question on Reorging a Very Large Table
  381. DB2 Rollfoward failes with error 24
  382. Help in using scalar function IDENTITY_VAL _LOCAL
  383. Retriving OUT value from sp of DB2
  384. restore database
  385. Are DBADM privs really needed for db2expln?
  386. CHAR vs VARCHAR
  387. My PCI auditor told me that my use of the IBM Encryption Tool for DB2 7.1
  388. Problems with Developers Workbench
  389. DB2 UDB LUW Command Line Parameter
  390. Uninstall DB2 client v7& v8
  391. DB2 UDB LUW Call to procedure from command line
  392. jcc type 4 driver locking issue
  393. column functions
  394. Moving stored procedures
  395. system call received a parameter that is not valid.
  396. does drop table command also drop indexes on it?
  397. IMS to DB2 migration
  398. explain how to resolve the error
  400. Excellent Software Testing Resource
  402. db2 blocksize for db2 backup
  403. SQL PL - Continue Handler and the use of FOR LOOP
  404. DB2 session looses schema setting
  405. Query Explain Tables Directly
  406. SQL3011C not enough storage to process the command
  407. Read BLOB locator and load the value to DB2 table
  408. Stored Procedure causing lots of entries on db2diag.log ...
  409. Select Data From Oracle And Insert Into Udb/db2.
  410. How can I determine the DB instances on a aix box?
  411. Is it a DB2 server
  412. CASE Stmt
  413. Adjusting LOGSECOND
  414. CLI0106E Connection is closed. SQLSTATE = 08003. SQLTransact: Error committing transaction.
  415. I would like to find a log about a DELETE
  416. Exporting Output of DB2 query to XLS in TOAD
  417. Current date in Table Constraints
  418. Database Creation
  419. Create Schema statement failed.
  420. How to identify the cause of an SQL30081N
  421. How to identify when last insert/update/delete done on the db2 table?
  422. CPU utilization by a certain query
  423. Explicit parallel processing of tablespaces with DB2_PARALLEL_IO on DB2 8.2
  424. db2 netbackup issues... Please advise/discuss
  425. accessing db2 v9 from within cygwin shell
  426. DID I FORGET TO INSTALL SOMETHING? cannot open shared object file
  427. Who's using DB2?
  428. DB2 Batch Jobs
  429. SELECTIVITY clause with BETWEEN predicate
  430. How to create multi-location/global views?
  431. Resolving SQLCODE -911 in IBM DB2
  432. REsolving SQLCODE -302 in IBM DB2
  433. Install Admin Client and FixPak
  434. Copying triggers
  435. listing db2 server
  436. Import does not complain about missing column.
  437. error try to use db2jcc do binding
  438. Function Sequence Error
  439. Connecting to database server through CLP
  440. db2
  441. possible to run Db2 with only the runtime client?
  442. UTF-8 impact on a database
  443. 32-bit Client connecting to 64-bit instance
  444. HADR Alternate Port?
  445. Static destructors in udb
  446. How to convert a DOUBLE to a string with no decimal separators?
  447. DB2 C header files
  448. cursor returned by stored procedure
  449. altobj() housekeeping
  450. An I/O error occurred while accessing the database SQLSTATE=58030
  451. DB2 XMLUPDATE error executing from Java Statement
  452. DB2SetCLPEnv_api not working with DB2 version 9
  453. MKT Tool : how to specify Remote DB2 database
  454. MKT Tool : how to specify Remote DB2 database
  455. migrating databases from v8.2 to v9: gives a nasty SQL0970N
  456. Exit DB2 CLP
  457. UDF table advice needed
  458. DB2 Replication
  459. enumerate db2 server
  460. ibm-CM - DB2 -ACL doesn't work ?
  461. Order By Nulls First/Last
  462. Import and self referencing foreign key
  463. DB2 DBA in NJ
  464. DB2 less secure than CICS???
  466. db2 sql clp
  467. UNION Problem on DB2 Ver 6
  468. -805 with ODBC access to SAMPLE database
  469. Passing parameters to a DB2 SQL script from UNIX script
  470. cannot connect to database
  471. Any designs required to enhance PARALLEL load
  472. Automated fixpak install on Linux?
  473. How to create DB2 DSN programmatically
  474. Recursive stored proc call
  475. LOGS
  476. Cannot create procedure with create cluster index in it
  477. DB2 CLOB performance V8.2.5 vs V9.1
  478. Help with Fresh V9.1 install on solaris
  479. Using functions in select statment
  480. Installation issues with DB2 PE 9.1.
  481. Loading query statements from file
  482. calculating elapsed time of script
  483. Set Schema programmatically?
  484. DB2 Unload (to record sequential file) on NT possible?
  485. SQL92 Join and DB2
  486. DB2 100% CPU Utilization
  487. Backup Failuare
  488. DIA0505I Execution of a component signal handling function has begun
  489. Comparing Column values
  490. TRUNCATE TABLE really exists, or?
  491. how to detect a deadlock and how to clear it when it occours?
  492. Restoring selected tables
  493. Problem with Stored procedure
  494. Export Table's layout
  495. GUID
  496. problem with DB2 Developer since updating to fp1
  497. "CATALOG DB" or "CATALOG DCS DB" for access DB2/400?
  498. update command options has no effect
  499. DB2 z/OS Text Searching
  500. Put DB2 in your search bar
  502. Tablespace rollforward condition
  503. DB2 Developer Workbench
  504. DB2 client
  505. question on Hash Joins
  506. Query related to Alphablox
  507. which jdbc driver to use
  508. DB29501E inconsistent environment
  509. Snapshot Statement - No statement text if in lock-wait state ?
  510. (missing) logfiles and crashrecovery
  511. DB2 Create tablespace performance Linux vs. Windows
  512. 42610 Invalid use of a parameter marker ?
  513. How expensive are idle connections?
  514. Java UDT
  515. Create UDT resulted SQL0107N exception
  516. SQL1084C error caused by db2start problem (Linux)
  517. sequence table.-urgent please respond.
  518. Extent Sizes and Page sizes
  519. Stored Procedure output into File
  520. Help for error: DRDA Application Requester, sqljrParseMrspReply2
  521. Can DB2 do a select with a TimeOut if it takes too long?
  522. USERID disabled
  523. FYI: IBM Support Toolbar
  524. DB2 Select Max Statement
  525. Converting from dms to sms
  526. Stored Procedure!! SQL0444n Reason 4!!Is this normal.....
  527. Can BINDADD database privilege allow users to bind an existing package?
  528. IBM OLE DB Provider for DB2 Codepage error.
  529. Count of a Group By
  530. restoring DB on test server after alt_obj() fails due to COPY YES
  531. getdate()
  532. DB2 UDB (Propagatable) Log records: Undo/Redo/Compensation/Normal: Explanation, subtypes, events
  533. How to open cursor to the resultset returned by stored procedure?
  534. Questions about some DB2 concepts.
  535. deleting large numbers of records
  536. What does error rc 2 mean for a userexit log archive?
  537. Full tablespaces; delayed garbage collection?
  538. SQL0443N even after binding db2schema.bnd
  539. When does LOAD COPY YES write the backup image ?
  540. defaults for the parameters in APIs
  541. Nested Select ..
  542. alphablox-cube views
  543. Informix
  544. Admin mode
  545. SYSPROC.ALTOBJ() does not copy DB2 comments over?
  546. How to find the next sequence of the db2 generated field in the syscat catalog table on db2 mainframe and db2 udb
  547. Arrancar base de datos en modo
  548. Defaulting ALL database columns in ALL tables - not allowing any NULL values...???
  549. DB2 administration server
  550. Command line-tools-problems