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