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. DB2 - OleDb - Unable to use Catalog Library List
  2. list applications only show one connection (catalog/uncatalog database)
  3. Can you tell if a REORG is in 'paused' state?
  4. getting comm errors in db2diag.log instead of sql errors
  5. Can you tell if a REORG is in 'paused' state?
  6. DB2LOAD API
  7. which data type to select
  8. DB2-Mystery with Multithreading and new compiler
  9. adding constraints to a view?
  10. Version 9 and .NET
  11. restore tablespace backup onto another system
  12. Storing some Japanese data.
  13. Traversing Relationship Tree
  14. db2 jdbc
  15. Cascading delete
  16. cursor as OUT parameter of a stored procedure
  17. cursor as OUT parameter of a stored procedure
  18. Path where database is created
  19. Error while connecting to a database
  20. SQL explain plan
  21. DB2 Development Center & COBOL for Z/OS
  22. String matching in LIKE predicate...
  23. Difference between DB2 Client and DB2 Connect
  24. DB2 Backup strange Problem
  25. Calculating percentage in sql db2 with decmial precision
  26. crash when trying to get snapshot size
  27. JDBC error
  28. DB2 Instance Crash
  29. Finding the 'Client login ID' aka 'Execution ID': DB2 AIX
  30. trigger happy
  31. db2 database online copy help?
  32. DB2 Trigger To Track Table Changes
  33. INSERT but ignore duplicates
  34. Sample table structure to store pics in DB2
  35. Thema: DB2 + XML-Funktionen
  36. SQL7962 Error When Selecting From AS400 DB2 Database
  37. Formatting a Timestamp
  38. How to upload a sql file as a member of a data set in db2
  39. How to upload a sql file as a member of a data set in db2
  40. user authentication
  41. Java / JDBC DB2 export
  42. DB2cca problems.
  43. software services
  44. EMC and DB2 on Z/OS
  45. Raw I/O on Linux
  46. DB2 Client run time for linux
  47. DB2 via REXX on Z/OS
  48. DB2 via REXX on Z/OS
  49. how to do DB2 RTCL upgrade on Linux
  50. SQL Tools for AS400/DB2?? What are you using?
  51. SET CURRENT LOCK TIMEOUT has no effect
  52. Regarding install_jar functioning
  53. Convert rows to column
  54. Convert rows to column
  55. GSS security plugin issues
  56. db2 connect required for accessing db2 on z/os?
  57. BEGIN ATOMIC, COMMAND CENTRE SCRIPT
  58. db2 connect required for accessing db2 on z/os?
  59. Naming conventions for datamart columns
  60. MQT
  61. SQLCODE -204 using a jdbc-driver to UDB DB2 v8.2
  62. Regarding install_jar ... Urgent
  63. SYSPROC.DB2LOAD
  64. SQL2038N A database system error "-5130" occurred during processing.
  65. Load Utility
  66. db2advis with stored procedures
  67. Error while running cron job with DB2 in RedhatLinux
  68. Moving tables to new schema
  69. DB2 Content Manager: Is it J2EE Compliant?
  70. DB2 DAILY CHECK LISTS SCRIPT
  71. Query Tools
  72. Utilizing db2mtrk..
  73. Trranslating ORACLE functions to DB2
  74. Help! inserting records and functions
  75. db2 connection error while running script
  76. CSV file with Headers
  77. How to do a sql update based on a join?
  78. Priming the Package Cache ?
  79. Slow stored procedure after upgrade to 8.2
  80. SQL error
  81. How to join those 2 char columns?
  82. Performance of load from a cursor .... federated cursor?
  83. DB2CODEPAGE Variable
  84. Moving cursor in Command Editor results screen results in update of table
  85. Data Conversion in DB2
  86. Parsing arrays parameters in DB2
  87. Multiple Instances and their corresponding entries in the services file
  88. calculation percentages using sql command
  89. DateFirst in SQL Server
  90. very interesting - why two equal calls is different?
  91. changed machine name - unable to work in DB2
  92. Mother Celko's Monday SQL Puzzle #3
  93. createin privilege
  94. Bad magic number for shared library: libdb2.so
  95. Bad magic number for shared library: libdb2.so
  96. db2pd -activestatements
  97. UnsatisfiedLinkError in Java UDF
  98. Datatype for creating a range value in db2
  99. -2 option in SQL table function for snapshot does not get global snapshot
  100. About Encrypted Data In DB2 UDB
  101. staring and stoping a database in DB2
  102. Can the notification log (.nfy) be deleted?
  103. Inserting Data using a Stored Procedure
  104. SQL1247
  105. SUM(double_value) is not deterministic?
  106. Query Tuning Help
  107. Index creation status
  108. DB2 Instance Crashing
  109. running utility task on all tables
  110. DB2 v8.1 (UNIX) on tape
  111. Performance problem in db2
  112. Third pary tool for db2 backup and recovery
  113. Using a cursor for Update
  114. Tempspace UDB V8 FP 10
  115. Tempspace UDB V8 FP 10
  116. How do we execute this command through java?
  117. Geographical clustering for DB2
  118. Searching for strings and replacing them
  119. multiple result sets
  120. Create DB2 USERS and Connect
  121. DB2 Instance Status
  122. Execution plans and temporary tables
  123. monitor lockwait
  124. Accessing the data from DB2 servers using C# Application
  125. DotNetNuke help Needed!
  126. FOR READ ONLY cursor a named statement
  127. DB2 performance variables
  128. import utility
  129. how to analyze db2expln results
  130. Obtaining parameter MAX_CONNECTIONS through the API
  131. DB2 Access Slow With MISys Application
  132. multiple outer join
  133. Server Security Plugin Error
  134. Cloudscape - usage of?
  135. DB2 Daily Check Lists
  136. Comments in SELECT via PHP/ODBC DB2 UDB v8.1.9 Linux, PHP 4.4.0
  137. Stored procedure slower than an ad-hoc query ?!
  138. Utilization Statistics during data load
  139. Tool to determine Hardware needs for a DB2 server
  140. Creating and using a Cursor
  141. Passing parms to a C Stored Proc
  142. Deadlocks even with SELECT FOR UPDATE
  143. An error on search table.
  144. TIps on Delete Cascade performance
  145. Table definition for Storing a PDF page
  146. Call for speakers: IBM Information On Demand 2006
  147. Error on adding DISTINCT to a SELECT DB2 UDB v8.1.9 Linux
  148. Sort memory
  149. Sort memory
  150. Errors in stored procedure in db2
  151. Problems with performing db2updv8 on database in db2
  152. automated-access-plan comparisons on LUW (db2 v8.2.2)
  153. SET integrity fails despite of for exception...
  154. DB2CMD in XP - DOS batch file
  155. Overflows in tablesnapshot
  156. SQL0954C -- Not enough storage is available in the application heap to process the statement.
  157. Creating a simple UDF
  158. set variables to be used in creation of result set.
  159. DB2 forum???
  160. Slow execution of Delete Statements
  161. Controlbreak flag in result?
  162. DB2 UDB Stored Procedure help
  163. creating pivot tables
  164. Index Naming Standards
  165. optimize DB2 query
  166. database backup -linux to windows
  167. Retrieving most current entry?
  168. EEE - Nodes utilization question
  169. Two tempspaces on database
  170. PLZ help me out
  171. Perl and DB2
  172. DB2 Queries
  173. Installation mess
  174. Create a table with a structured UDT (user-defined type) as a column
  175. Tasks not found in version 8.2
  176. can i use load terminate with cursor for select * from table name?
  177. Passed DB2 UDB 701 test, how can I prepare for 704 test (Advanced DBA)?
  178. Problem with DBD::DB2 and UTF8.
  179. FYI: FP11 and error -925
  180. Running multiple SQL scripts in the background ... no longer possible?
  181. column "generated always as" generated from multiple columns
  182. How to locate the static SQL fired by an application in DB2
  183. The HighValues plague returns....
  184. problem with procedure call
  185. View DB2 Table definitions in QMF
  186. backup question
  187. partioned table or partioned index
  188. DB2 Experts To Contribute To 85K Newsletter
  189. identity-alteration RESTART option
  190. DB2 version 8 DBA (Houston, TX.)
  191. DB2 Connect returning data in HEX?
  192. SQL Cross join
  193. Language Issues
  194. redistribute nodegroup
  195. Rename a database?
  196. Install IBM DB2 on Fedora Core 5 (Bordeaux)
  197. Sudden excessive access time to DB2 via ODBC?
  198. Accessing DB2 on an AIX server via ODBC from MS Excel
  199. SQL stmt to find if table is in load pending state?
  200. IGNORE NULLS possible fro CREATE INDEX? DB2 UDB v8.1.9 Linux
  201. Syntax question DB2 UDB v8.1.9 Linux
  202. Storing Japanese characters in UTF-8 database
  203. Naming ...
  204. Naming ...
  205. GENERAL SQL Question
  206. Help performace question DB2 UDB v 8.1.9 Linux
  207. Truncate Table
  208. column functions
  209. How to recover db2 instance user's privilege?
  210. remove spaces from field contents in DB2 database...
  211. DB2 Backup
  212. Privileges on SP??
  213. I need help
  214. HADR and failed tablespace creation
  215. Multiple SQL SPs accessed from one SP
  216. how to create a DB2 system dsn in linux fedora core 4
  217. Writing file from procedure
  218. Replication using asnload
  219. can someone help me figure out what caused the rollback?
  220. DB2e_Shadow
  221. DB2 Version 8 - libeay32.dll problem
  222. SQL0298N Bad container path Error
  223. Log Full
  224. Duplicate rows from a SELECT DISTINCT DB2 UDB v8.1.9 Linux
  225. Open LDAP Plug-In Anyone?
  226. Multiple Temp Tablespaces
  227. z/OS to AIX connection - authentication/authorization
  228. Viper and VisualBasic
  229. Calling SYSPROC.DB2LOAD within SQL stored procedure
  230. Moving db2 to a dedicated partion
  231. Should db2 summarize or home grow a build app in C
  232. problem with long object name
  233. FETCH FIRST ROW ONLY
  234. plz help me out
  235. delete from table where in, problem
  236. top-down-top query approach
  237. MERGE in V8.2 FP4 (on condition returns multiple rows from target)
  238. Differences between UDB V7.2 and V8.2 for federated connections?
  239. Uninstalling v7.1 on Solaris
  240. re-configuring db2 server for client operation? [comparison to oracle]
  241. Compiling stored UDFs
  242. Parameter Markers in SQL queries and ADO.NET
  243. Lock escalation in SYSCOLDIST
  244. help me out
  245. How do I do this in DB2
  246. DB2 Viper Testdrive
  247. SQL0902C - SQLSTATE=58005 - Reason Code = "14"
  248. Seek newbee Java UDF installation tip
  249. Blocking Agent ID for Locks in SNAPSHOT_*
  250. Multiple temp tablespaces with same page size
  251. Multiple temp tablespaces with same page size
  252. ADO.NET - strange behavior
  253. About automatic database maintenance
  254. db2pfchr processes and high CPU
  255. Catalog Database
  256. Problem with Global Temporary Table
  257. About Multiple Cursor from Stored Procedure
  258. db2cmd.....
  259. SQL issue? Can this be done?
  260. Reading an explain Plan
  261. Functionally equivalent exception Join
  262. Command Editor problem?
  263. Extended optimization messages
  264. Is "One view per table in DW" really a good practice?
  265. locks and related
  266. Confused on how to get a percentage of total using OLAP functions
  267. slow download-insconsistent latency
  268. DB2NTMEMSIZE
  269. db2diag.log error
  270. Need ROLLUP expert advice!
  271. Is there a way to find the record causing SET INTEGRITY command to fail?
  272. Problem inserting spanish characters in DB2 UDB
  273. Problem with Backup/Restore with Vendore Products
  274. How to Drop data from table quickly
  275. db2_evaluncommitted
  276. Parameter.Add need help - not understanding
  277. DB2_FMP_COMM_HEAPSZ - need help!
  278. Sequences in db2 8.1.0.36.
  279. Grouping SQL statements
  280. SQL6024E Table or index "tab_name" is not defined on node "0".
  281. SQL Server co-existance
  282. how to rollforward without userexit - SQL1268N
  283. db2 File system caching ..DIO or CIO??
  284. db2 File system caching ..DIO or CIO??
  285. db2 File system caching ..
  286. Control Center Error
  287. Alter Column
  288. Illegal Immigration, the Non-Issue of the Week??????????????
  289. How to obtain the schema from a JDBC Connection ?
  290. 2-nd edition of Celko Puzzle book in the works
  291. Truss output - semget analysis
  292. Inserting data into a DBCLOB column
  293. Passing a parameter to IN predicate of DB2 udf
  294. LOWER() and UPPER() functions not found.
  295. limiting number of rows returned by resultset
  296. Control Center doesn't find backup files
  297. Issues with loading 124 million records
  298. Set level acestor report; DB2 UDB 8.1.9 Linux
  299. Restore not finished
  300. Query performance
  301. jdbc and list of all databases
  302. Is db2uext2 archiving directly to tape?
  303. DB2 Application Development Client
  304. creating a database using DB2
  305. Mixed Case in table and column names.
  306. T-SQL to DB2 UDB SQL-PL conversion...
  307. SQL construct conversion...
  308. Can't get table out of check pending state after load.
  309. Group Authentication
  310. DB2 V8 z/OS
  311. What's wrong: SQLCODE -30082 password missing (on windows)
  312. SQLCODE -1024
  313. Computing the product of a column groupped by...
  314. Triggers crashing database ?
  315. Migrate DB2
  316. SQL1224N - A database agent could not be started to service a request
  317. jpg file to mainframe
  318. Mixing SQL and traditional I-O in an ILE COBOL program
  319. Query Performance
  320. DB2 Control Center crashes
  321. insert data into graphic column
  322. Shell Script eroor while using db2 export
  323. Locking issue
  324. regd data migration from DB2 v7.2 to SQL server 2000
  325. i can not create db2 sample
  326. Transaction Log full.
  327. # of Agents -> db2 list applications
  328. Tablespace on NFS (Netapp filers)
  329. deadlock related
  330. [IBM][JDBC Driver] CLI0622E Error accessing JDBC administration service extensions.
  331. Authorization/Privilege Issue
  332. SQL/PL Stored Procedures and SYSIBM.SYSDUMMY1
  333. Case Sensitivity in DB2 on linux
  334. alter query
  335. DB2 Query problem
  336. DB2 UDB Detective - Ace Ventura
  337. NULLID.SYSSN300
  338. Logging
  339. odbc connect string and library list
  340. SQL help
  341. Is LOAD really this brain damaged?
  342. Sequence number for a Batch
  343. Help me to Create Database
  344. DB2 Redirected Restore
  345. About Encryption Function in Db2
  346. iSeries: JDBC problem v5r3
  347. multi-file multi-table import
  348. table identifier for db2ReadLog
  349. Simple Query
  350. to fetch first record
  351. DB2 exception handling in triggers
  352. DB2 error handling in triggers
  353. How to get generated key back in php/db2 v8.1.9 Linux
  354. How to do more things in DB2
  355. Is this the right way to go about ranking things?
  356. Backup a suspended database with SMS tablespaces possible
  357. nonrecoverable load during backup
  358. User Defined Function in DB2 Urgent Help please
  359. Exporting current system timestamp to unix server
  360. Timestamp equivalent in DB2
  361. SQL0818N after V7 -> V8 migration.
  362. IXF LOADing w/ different column orders
  363. Sql help
  364. DB2 SQL error: SQLCODE: -805, NULLID.SYSLH20A 0X5359534C564C3031
  365. DB2 CF and Visual Studio 2005
  366. How to load a cursor from a stored procedure in DB2
  367. Strange error:An unexpected token ")" was found...Expected tokens may include: ")"
  368. 2 version of admin client on same PC?
  369. about high security field
  370. DB2 Incremental BackUP / Restore problem from one machine to another
  371. Checksum for Duplicacy check
  372. Catalog-view to get tablespace-state?
  373. Places to schedule database backup in DB2 UDB V7
  374. Cursor Load fails with SQL0964C error
  375. Merge Alternative
  376. Upgrade my db2 8.1 fixpak 6 to last release
  377. V8.2 Express Edition XP Home
  378. task center error 22207
  379. size of db2 udb database
  380. Ink
  381. Just for laughs..
  382. Migrating DB2 UDB 8.2 dbs from windows platform to Linux
  383. Building Simple SQL Stored Procedure
  384. Ink
  385. HELP! reading syscat from php in db2 udb v8.1.9 Linux
  386. Recover IBM DB2 Data (Urgent)
  387. Senior Mainframe Cobol CICS DB2 Programmer Needed in Alabama
  388. Stored Proc Performance Improvement
  389. Stored Procedures / UDF
  390. DB2 program to read log files ... incorrect function identifier
  391. Data Replication DB2 VM to UDB with DPROP
  392. Data Replication DB2 VM to UDB with DPROP
  393. DB2 Backup into 3590 tape drives
  394. Difference between Collection ID and qualifier
  395. problem with Group By
  396. Comparing dollar amounts stored in a varchar
  397. Adding user data to the system metadata tables Db2 UDB v8.1.9 Linux
  398. DB2 and embedded SQL
  399. Expected Impact of Changing Logging Type
  400. get a list of all users in db2
  401. Query performance - Please help
  402. extracting db2 table records to csv
  403. How can i connect to tables created in a schema with a username different from the schema name?
  404. Drop Table
  405. Optimizer not using MQT ?
  406. load data into varchar column
  407. Relocate DB2 databases part 2
  408. How to convert DB2 data type P to SQL
  409. What is the connected database?
  410. How do i ensure 'insensitive' (ie static) cursors that are only forward readable (in DB2 for mainframe)??
  411. Select the 2nd of a sequence of rows in a table
  412. SQL to get the max or min record which one is better?!
  413. What's incorrect with this function?
  414. Relocate DB2 databases
  415. DB2 Rollforward DB query status
  416. DB2 + shell script
  417. Is there a way to import tab delimited files into a db2 table?
  418. DB2 Table Editor Search Conditions
  419. load from cursor
  420. load from cursor
  421. UNIX shell script and DB2 Queries
  422. Sort after index scan
  423. OS/2 (yes) backup to XP Excel
  424. Inserting into temp table using Cursor
  425. Changing an index controlled partitioned table to table controlled.
  426. Alert notification time
  427. MDC + Partitioning Key
  428. SQL Query to concatenate columns
  429. Statement Isolation Level
  430. Concatenating rows ?
  431. generated columns for z/os
  432. Uregent finding difference between count of two coulumns
  433. How to get instance's server port?
  434. Selecting only letter and number characters
  435. SQL1031N error help
  436. UDB sort sequence problem
  437. report issue
  438. How do I prune db2rhist.bak and db2rhist.asc?
  439. Generating SQL Scripts from SPUFI
  440. How to find out the Java Version in DB2 personal edition 8
  441. select count(*) - Full table scan
  442. Convert DECIMAL to DATE
  443. Restore to new node using TSM fails
  444. Error while running sdl scripts
  445. Parallel Database
  446. WPAI on iSeries DB - Problem
  447. CLI Wrapper for .NET Platform
  448. DB2 UDB Error Handling
  449. Bulk Load BLOB using DB2 CLI
  450. Easy Group By Question (I think/hope)
  451. Puzzled
  452. How to do...well...anything...in DB2 SQL
  453. DB2 - Decode Compiled SQL Statements
  454. Exception Handling in DB2 UDB
  455. Exception Handling in DB2 UDB
  456. Restore into DB2 replication database
  457. Isolation Level inside C++ routines / Slow performance.
  458. Database metrics
  459. DB2_LARGE_PAGE_MEM
  460. db2exfmt - client
  461. Product license ? Run time client ?
  462. Preserving comments when creating SP's from Command Editor
  463. Comments in Selects DB2 v8,1.9 UDB Lunix
  464. Lookig for a copy of "The ABCs of Plans and Packages" by Nicola Nur
  465. Trouble connecting to DB2 in Visual Studio 2003
  466. DBA cert
  467. Urgett !! redirected restore of a tablespace
  468. How to kill idle connections or sessions
  469. Max Connections
  470. Packages, Bind, Prepare and Execute
  471. Max Connections
  472. How to get my current connection id in SQL
  473. benefits of 64-bit db2 apart from addressability
  474. creating a Report
  475. have some fun and forget the problems
  476. CLP Execution
  477. db2 and the strip function
  478. DB2/COBOL Store Procedure Parmeter List (Reply)
  479. CPU Time (User / System) & Actual Elapsed Time for SQL
  480. DB2 8.2 32bit to 64 bit conversion
  481. Running a batch of sql queries?
  482. Running a batch of sql queries?
  483. DB2/COBOL Stored Procedure Parameter list
  484. Multiplatforms?
  485. Could you clarify IY63894 ?
  486. More than one CURRENT TIMESTAMP in a PROCEDURE
  487. Is it possible to move the ICMNLSDB database from one drive to another?
  488. how ADM1822W could happen?
  489. DB2 RT Client silent install
  490. refresh view ?
  491. federation
  492. Import Problem Urgent
  493. JDBC Type 4 Universal Driver SQL Error Code = -99999
  494. Data Warehouse Cube View Control Center
  495. Package cache hit ratio
  496. DB2 Connect Ver. 7.2 Client Assistant Export problem in Windows 2000
  497. DB2 Connect Ver. 7.2 Client Assistant Export problem in Windows 2000
  498. delete statement after a RETURN CURSOR in SP ?
  499. Convert TimeStamp
  500. give me idea for this problem
  501. give me idea for this procedure
  502. Federated database and host privileges on SYSIBM tables
  503. Query regarding Index
  504. Debugging SQL stored procedure using developement center
  505. Debugging SQL stored procedure using developement center
  506. DB design
  507. DB2 Sample Test Question? Which is the correct answer?
  508. Basic SQL prcoedure question
  509. Problem using db2sql92 on host db2 (Langlevel or missing package)
  510. DB2 Altering an integer to character type
  511. How to connect to the DB2 on a REMOTE machine from a C++ application on Linux?
  512. Connectting to as400 from DB2 ESE running on Windows XP
  513. Online Tablespace restore from incremental backups
  514. SQL0901N Error.
  515. Export af Tasks from Task Center
  516. DB2 ESE add Partition fail
  517. estimated execution plan
  518. FW: SR 603066805 : FW - Firewall in transparent mode with excessive packet drops
  519. Hast Du das schon gewußt?
  520. Special considerations to backup using ntbackup
  521. Report formating
  522. websphere vs sharepoint
  523. Aggregating strings
  524. Test database connection using C++
  525. memeory usage
  526. Licensing Issue
  527. my db2 routine deleting records with commit count ,any advice ?
  528. DB2 Replication Centre Issue
  529. online monitoring of sql statements
  530. Cannot Execute Create Server
  531. modelling tool
  532. Strange Errors in db2diag.log
  533. DB2 Certification exam 700 and 701 Question papers
  534. UDB: Backup Image Size & Used Pages Size
  535. problem with ibm db2 8.1 fixpak11
  536. urgent - Formating issue
  537. "SQL1024N A database connection does not exist" when using db2GetSnapshotSizeData and db2gGetSnapshot
  538. Import invoked from stored procedure
  539. external table function in DB2 LUW
  540. DB2/400
  541. Is DB2 8.2 ESE compatible with W2K3 Terminal Services?
  542. Problem with MERGE statement: SQL0969N Error Code: -788
  543. DB2 Environment Setup
  544. Provider cannot be found - Using current MDAC and Jet
  545. Restore DB2 System Tray
  546. DB2 Image Extenders
  547. INTRA_PARALLEL
  548. Pb load command JDBC driver
  549. db2 memory
  550. db2 memory