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