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