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 connect to db2 database
  2. -811 SQLCODE Behaviour !!!
  3. DB2 database IDE
  4. instance creation problem
  5. Can I access DB2 DB with Toad Client
  6. IOs in DB2
  7. how to use COALESCE?
  8. DW Specialist
  9. Cursors
  10. Data change table references and SQLCODE -20165
  11. How to compare several rows in one table???
  12. space utiilization in a DMS tablespace
  13. Error While installing DB2 on RHEL5
  14. DB2 & Oracle source code reusability
  15. Db2Viper2beta on Windows Server 2k8beta3?
  16. Can stored procedure have call to subroutines
  17. join with example
  18. fetch cursor
  19. Stored procedures and Global temporary tables
  20. DB2 DBA 702 Certification exam
  21. DB2 Logging in Materialised queries
  22. db2 with cd
  23. Insert into AS400 table locks bacuase of trigger
  24. prevval and nextval for a sequence
  25. Deadlock/timeout error
  26. Stored Procedures Updates
  27. Restoring, can't redirect tablespaces
  28. Sort Performance
  29. Able to alter or drop a table but cannot create the table, when no permissions are given to that user
  30. SSIS and DB2 Schemas
  31. IMPORT with METHOD N
  32. how to import db2move.lst
  33. size of the database ?
  34. DB2mscs command
  35. Granting DML privileges on all the tables of a schema to a user
  36. Runstats Utility
  37. Short circuit boolean eval in trigger WHEN clause?
  38. Sqlcode +97
  39. SQL need to be optimized
  40. Delete/update Sql/400 Stored Procedure Not Working
  41. History query question
  42. Basic Cron job not working in UBUNTU
  43. faster CPU vs more RAM
  44. waiting on archive
  45. Create Table sql0204 error
  46. SQLPRIMARYKEYS corrupted
  47. IBMDEFAULTBP setting
  48. "I" is not valid in the context it is used - db2 command line sql
  49. db2updv8 necessary for FP14 -> FP15?
  50. oad done on a table with nonrecoverable option on a archive loging enabled Database
  51. Main differences between DB2 v7 & v8 in a Z/OS env
  52. Writing a stored procedure in command editor
  53. Write a cobol program without using session table
  54. Improving Performance in DB2
  55. DB2 Not ATOMIC Compund SQLs
  56. Fixpak installation in db2 udb
  57. Syntax to Update Timestamp Column
  58. How to run db2commands in windows cmd prompt
  59. Reason for DB2 error code Sql0204n
  60. How do you get load to reject and not truncate data
  61. DB2 error SQL30081N on AIX version 5.2 / 5.3
  62. dropped a not null column from a table, error while running stats
  63. dropped a not null column, having problem in Update
  64. Definition of empty table
  65. DB2 Installation Problem
  66. Executing DB2 commands from Windows command prompt
  67. The database alias "MONITOR" already exists Can't Not Drop it
  68. Invalid cfg for DAS tools catalog (or maybe db2fm)?
  69. Sorting data within inline queries
  70. Hang on archive
  71. XSU Java package with DB2
  72. Tracking DML changes for important tables
  73. writing output of Stored Procedure to an outputfile
  74. Restore backup performed on Unix server to a Windows server
  75. some arbitrary application ids in "db2 list applications"
  76. tracking DML on important tables
  77. Automatically disconnecting DB2 clients which are inactive for some time
  78. Efficiency of DB2 LOAD RESUME vs REPLACE
  79. fortran db2 on Windows
  80. OracleXMLQuery class with DB2
  81. Unresolved external with DB2 v9
  82. Informix current sessions with database names
  83. ORDER BY CASE Problem
  84. db2 CASE statement in ORDER BY clause
  85. ODBC connection to V7 and V8 databases simultaneously
  86. Verify File before import
  87. Java scalar function slow
  88. .Net Framework Data Provider for DB2?
  89. Table Functions using Db2 on Z/Os
  90. INSERT binary data
  91. Insert using RRN?
  92. DB2 as web service client?
  93. Interface tools for DB2
  94. SQL1032N No start database manager command was issued. SQLSTATE=57019
  95. TSA binary for Windows
  96. That works faster in DB2 for creation of an index?
  97. Adding a not null column to a table with 0 rows
  98. db2_deinstall command
  99. How to use DB2 ODBC on z/os with COBOL
  100. Error comes when insert records
  101. SQL0440N No authorized routine named "||" of type "FUNCTION" having compatible arguments was found.
  102. Mainframe file loaded into DB2 table
  103. Use of SELECT [Fields] INTO [var] in UDFs
  104. How to find out last REORG timestamp ?
  105. HADR primary to standby
  106. ADM1844I - Many Many Warnings in the event viewer... Why ?
  107. DB2 privileges, Direct and Indirect SYSADM
  108. How to Handle IF THEN ELSE IN DB2
  109. Effects of Increasing the locklist parameter
  110. Problem with accessing 2 different tables using the same binary
  111. Combine queries for single output
  112. Another Bizzare Crash...But no Recovery. SOS!!
  113. SQL Server 2000 linked server to Db2 on z/OS
  114. DB2 Merge performance
  115. informix/db2
  116. DB2 function
  117. How to write query with two select statements in db2
  118. SQL or stored proc
  119. rid
  120. Odd Diag Log Message on V9 FP2
  121. load/import in db2
  122. how to change user password
  123. query runtime problems - same tables joined together
  124. How to IMPORT MS EXCEL worksheet in Kanji (Japanese) to db2/400
  125. maximum number of column can be set as Primary key in DB@ V8
  126. updating the locklist
  127. How to get the zero's for unsatisfied fields in group by clause in DB2
  128. Need to connect to Db2server
  129. converting Oracle PL/SQL function to DB2 v9
  130. Sqlstate 42972 from Query
  131. stored procedures perf. question
  132. Data load in DB2
  133. db2 exam 701 dumps
  134. Return columns using db2_columns() via PHP
  135. print value during execution stored procedure
  136. Query question
  137. Indexing of table in DB2
  138. setting user name password and user name for automating create script
  139. High water mark
  140. declared global temp table with merge
  141. The Question about REDIRECT RESTORE
  142. sql error -530
  143. When should we Reorg
  144. Background Process for Reorgcheck
  145. Background Process For Backup
  146. db2 on raid5, striped disks, SAN
  147. Alter column precision
  148. Select null as xyz from sysibm.sysdummy1
  149. fastest way to delete 1 billion rows from a table haveing 9 billion records
  150. Select null as xyz from sysibm.sysdummy1
  151. Generated Column
  152. Poll: DB2 V9.1 Adoption
  153. Count the transactions happened in a database
  154. Describe Sql View
  155. Select From Db2 W/php Error
  156. Not a trial, a commercial tool you can use for no charge for as many databases as you want
  157. Backup Information
  158. compare the tables between TEST and DEV
  159. DB2 Control Center not responding
  160. Is there any attribute which indicate the last access date?
  161. How to determine the DB2 version
  162. Querying "Sequence" in Select statement
  163. Got a intresting problem
  164. Backup Information
  165. Conversion of Oracle 9i to DB2 V9
  166. Software Testing Tools
  167. Sybase to DB2 Data Movement
  168. expanding a default value
  169. DB2 V8 (mainframe) Install - 'Resource Not Available' Msg
  170. how to replicate the SQL Server 2005 Procedure to DB2?
  171. DB2 execute permissions issue
  172. Disabling the DB2DETAILDEADLOCK event monitor
  173. Problem in Automatically generated columns while copying schema
  174. "channel DB2"
  175. When is an offline backup not really offline?
  176. Incorrect results using FULL OUTER JOIN in DB2 v8
  177. DB2 Two "how to" questions - [conditional loading and variable use]
  178. DB2 Automated Backup configuration parameters (DB2 UDB v8)
  179. package name restrictions
  180. Selecting Field Description With DB2 and SQL
  181. Archiving Older Data
  182. SQL0206N "BLOB" error
  183. DB2 on AIX throw exception with SQL that has (
  184. DB2 V8.2 - Value compression question
  185. problem with POSSTR
  186. Error while declaring a global temporary table
  187. INSERT IGNORE in db2
  188. J2EE Professionals for Bahrain
  189. Reading Tables & Columns
  190. db2 restore database
  191. Multi Row Insert using an SP in DB2
  192. exam cost??
  193. using Dynamic SQL for Update
  194. Express-C
  195. DB2 Viper 2 compatibility features
  196. Dump of a schema in DB2 / Admin_Copy_Schema
  197. Database Size Problem
  198. Funny
  199. Help me on Query fine tune.Explain report details provided.
  200. Problem with AutoCommit & problem with XML insert
  201. Db2
  202. setting the termination character in CLP
  203. Nested case in DB2
  204. Nested case
  205. DB2 Z/OS Stored proc help
  206. Db2
  207. setting pause on output in CLP (Db2 9)
  208. How to change a column from a not null to null
  209. Oracle EXPORT and DB2 LOAD
  210. SAP DB2 userids
  211. Perl DBD::DB2 connect error
  212. COM.ibm.db2.jdbc.app.DB2Driver
  213. How to insert and retrive data from Visual Stidio 2005 (MFC) into DB2???
  214. IBM][CLI Driver] SQL1032N No start database manager command was
  215. How to export resultset to CSV
  216. How to export resultset to CSV
  217. How to export resultset to CSV
  218. How to export resultset to CSV
  219. How to export resultset to CSV
  220. if "all applications disconnection" is anathor tigger of page cleaner?
  221. killing application/thread automatically
  222. importing data with CR-LF
  223. Insert values into a table B based on a flag on table A
  224. Sql performance Tuning
  225. Database inconsistant?
  226. Sql-Translation: Oracle to DB2
  227. DB2-quries
  228. lock escalation
  229. Unicode...
  230. Tablespace STUCK in Roll Forward in Progress State...
  231. How to make a generated column function of other columns?
  232. db2 pring command for dynamic queries
  233. Calling a nested stored procedure in DB2
  234. Performance of JOIN vs. singleton SELECTs
  235. How many cursors?
  236. What are the process to add another DB2 database to existing Instance?
  237. connect as400 to mysql
  238. substr of a number's field
  239. Emptying index advisor cache
  240. DotNet compatibility of BLOB datatype
  241. positioned update
  242. Tablespace remains full after deletions
  243. Big problem with DB2 and Clobs...
  244. How can i Connet from 1 DB2 Server/Client to Remote Server on AIX
  245. The Best DB2 Articles
  246. DB2 Automated Backup configuration parameters.
  247. Need help getting DB2 Connect to catalog a remote AS400 DB2 server
  248. Load Data from fixed length/delimited feed file
  249. How to get System Date in DB2 with SQL Statements
  250. I need help to fine tune below query..urgent please.
  251. MIGRATE DATABASE from 7.2 to 8.2
  252. How to find no.of deleted rows
  253. DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501
  254. Examination 070-229 Resource
  255. ERROR SQL in DB2
  256. Restoring the event monitor file
  257. plz help:i want to create db2 account Not using OS account
  258. CREATE PARTITIONED TABLE - SQL0104N error
  259. 5th Fast Track Automation batch from Quality Globe from August 9th.
  260. SELECT of Members
  261. inserted values required with the given format
  262. Compare two databases in different subsystem
  263. Lock Escalation
  264. Troubles inserting to a new unicode table....
  265. clientside backup of partioned database
  266. quiesce database problem
  267. Prevent database user to access another database
  268. Use of REORG TABLE in a C++ Applikation for db2 Version 9
  269. CLOB columns change after database restore
  270. Need to display the header as the top row in the recordset
  271. Laptop Version ?
  272. Db2admin password
  273. check constraint
  274. DB2 load utility and subsytem
  275. DB2 Concepts
  276. DB2 Vers 8.1 installation error on WinXP
  277. DB2 connectivity
  278. TCP/IP Communication Error
  279. mainframe (7.1.1) lock escalation
  280. application id
  281. how to get even or odd number rows from database in db2
  282. [Question] DB2 LUW V8, regarding after drop tablespace behavior
  283. DB2 INSERT search for space
  284. runstats from reorgchk update stat
  285. Outer Joins in MQT`s
  286. migrating SQL Server data to DB2
  287. SQL stored procedure in Z/OS (DB2 ver 7)
  288. how to *really* remove a database in DB2 ..
  289. Insert v/s Load
  290. creatin a trigger
  291. To create a trigger
  292. xml
  293. connection remote to DB2 database with the C/C++, with prohibition of installation DB2 client software.
  294. execution time in HADR
  295. ClientBean and ReportBlox
  296. V8.2 Check if nonrecoverable load was done
  297. sql update to a substring
  298. V9 Column Rename
  299. HADR performance issue
  300. Sqlstate = 56038
  301. db2 replication Center
  302. Error activating a database/cannot allocate agent
  303. DB2 Common gcf error
  304. QMF vs SPUFI
  305. import from NUL converted to ordinary delete
  306. Problems with starting DB2 service on windows
  307. SQLJ default context override
  308. DB2 queries
  309. Migrate Data from Oracle 10g Express to DB2
  310. Order of Where and Composite Key
  311. Stored Procedures for DB2 z/OS Developed with SQL Language
  312. Very basic formatting question
  313. DB2 Container Size Limit
  314. at the start of db2
  315. First process in db2 startup
  316. Errorr execute immediate
  317. displaying a date
  318. Get error SQL0723N when trying to insert a row into mainframe DB2 from web server
  319. Mqt Store Procedure
  320. Newbee Query Problem
  321. IN versus ANY versus EXISTS
  322. DB2 Load utility
  323. describe command
  324. Specifying Record Delimiter
  325. SQL0338N-Error
  326. Delete rows from two tables
  327. db2 sql query
  328. SQLCODE: -805, SQLSTATE: 51002 , this is the error code
  329. Temporary table in DB2
  330. Summing a column as a seperate column in the same query
  331. db2_pconnect SQL10007N Reason code: "3"
  332. Nested selects
  333. Invoking Stored Procedures in Triggers
  334. Oportunidade Stefanini It Solutions
  335. BEFORE OPTION
  336. Max length Locate can handle
  337. MF COBOL/DB2 Error
  338. Clob In Db2 Aix
  339. DB2 "Net Search Extender" for v9.1
  340. Define a return value in store proc.
  341. Creating Function Template in UDB 8.2 with TABLE return type for Federation
  342. SQL Error in DB2 and MS Access
  343. DB2 migration utility ?
  344. Looking for a db2 tool that converts Oracle to Db2 - Migration assistant?
  345. DB2 Express-C on Windows XP SP2 "Invalid parameter number. SQLSTATE=S1093"
  346. 64bit client application in a 32bit instance
  347. Software Testing Cycle
  348. DB2 Certification Exam question
  349. Packages and Procedures
  350. DB2 online data copy
  351. Db2-cobol Program
  352. Isolation level - interesting scenario
  353. Update difficulty
  354. Interesting isolation level problem
  355. access level problem in multiple instance
  356. db2 offline db restore from v7.2 to v8.2
  357. Version Recovery (Db2 on AIX)
  358. Formatted CURRENT DATE
  359. SQL0104N An unexpected token "DATABASE" was found following "CREATE ".
  360. After merging - how to bring over parent_ids
  361. DB2 database shutdowns after excecution of sqlj procedure
  362. VARCHAR field that is not NULL
  363. DB2 ver 7.1 Processing was cancelled due to an interrupt
  364. Help on Null
  365. LIbrary System
  366. db2 704 exams
  367. Very urgent.. need threshold levels for db2 monitoring metrics
  368. SQL Code -181
  369. 4th Fast Track Automation batch from Quality Globe from July 24th.
  370. iNFO O db2 CERTICATION REQUIRED.
  371. How to reduce the ImageCopy job run time
  372. how to ignore errors when creating stored procedure?
  373. help in DB2 Load command
  374. db2 wsad connectivity
  375. Import SPF via Script
  376. SQL0332N There is no available conversion for the source code page
  377. library system
  378. SQL0206N, case statement and time calculation
  379. Failed to load libaio
  380. Asp - Db2
  381. db2 doubt
  382. Catalog Node : Port Number
  383. HELP! declare global temporary tables?!?
  384. HOW to convert a character type into date format
  385. need a little insight on index that allows reverse scans
  386. select from a sequence and from a table in the same statement
  387. update from a select
  388. Storage quantity
  389. Commit Active problem solved (db2rhist.asc)
  390. STOP RUN in DB2 stored procedure
  391. how do you add a zero to the left of an integer
  392. view tables
  393. Retrieving latest row
  394. Error in DB2 (COBOL/DB2/CICS )
  395. Space instead of Null
  396. plan and package
  397. IBM supplied WLM stored procedures
  398. Client compatibility
  399. Oportunidade Stefanini It Solutions
  400. How does threads work in DB
  401. load vs. import ( warnings )
  402. row_number
  403. LOAD and LOAD with AMDIN_CMD
  404. Replication tutorial
  405. DB2 subsystem
  406. SQLCODE groups
  407. Db2
  408. Is there any command or tool for doing DB2 Catalogs reorg/check?
  409. complile and execute a stored procedure.
  410. Run DB2CMD commands through PowerShell
  411. DB2 versus UDB
  412. Controling tablespace for a primary key index in alter table
  413. Db2 700
  414. Need help on data replication and available options
  415. Rename a tablespace file?
  416. Is there any way to make my transcripts of the DB2 certifications viewable for public ?
  417. How to speed up this SQL statement
  418. How to extract sequences in db2 udb 8.2
  419. log table changes with a trigger...
  420. IBM and AGS Announce Availability of New Solutions for Informix Dynamic Server
  421. Contokens
  422. check pending state
  423. message in db2diag.log
  424. DB2Dart Report meaning
  425. problem during database connection test in db2 stored proc
  426. db2dascln
  427. db2 iseries
  428. Application inventory DB
  429. list of parameters that has to monitored by a DBA in db2 UDB
  430. list of Parameters that has to monitored by a DBA in db2 UDB
  431. Renaming an instance
  432. Could this be DB2 or an Access problem??
  433. How to take the database backup
  434. How to define my own exception in db2 stored procedure
  435. DB2 Trigger Help
  436. update a column on particular table relation with multiple tables
  437. ROW_NUUMBER LOOP
  438. Software Quality Management
  439. Need Help with db2 db2start throwing SQL6048N error
  440. Query help...
  441. DB Backup error
  442. DB2 Driver- ClassNotFoundException-Please help
  443. Oportunidade Stefanini It Solutions
  444. Ibm Db2 Sql
  445. Error in loading data into DB2 table
  446. common problems found in db2
  447. Universe locks
  448. command for viewing DB2 configuration parameters
  449. IBM Establishes Global Center of Excellence for Nuclear Power
  450. Corrupt Trigger Nameless
  451. Stored Procedure
  452. Error uninstalling DB2 V9.1 (XP Home)
  453. DB2 700 Exam
  454. SQLDA corrupted when using VARGRAPHIC type parameters
  455. DB2 Certification
  456. db2ReadLog, Variable format data
  457. How to do DB2 Clustering
  458. db2jstrt or db2jd on OS/390
  459. db2look -tw
  460. What are the Files generated after db2 installation
  461. Cobol precompiler query
  462. Installing and Operating DB2 Within Windows Domain
  463. Tables and Columns security in database db2
  464. Long running of DB2 Queries
  465. Creating Indexes For Declared Temporary Tables
  466. How to execute a procedure in DB2
  467. CMMI Practices
  468. DB2 trigger failing while calling stored procedure
  469. How to change the primary key for already existing table?
  470. Statistics with volatile table
  471. Cannot Load
  472. Third Fast Track Automation batch from Quality Globe from July 5th.
  473. "Best Fit" Match against multiple tables?
  474. PHP5, ibm_db2 connection problem
  475. COBOL DB2 V8 Mainframe - moving data from one table to another
  476. Primary Key
  477. DB2 Model
  478. Primary Key
  479. specified attributes not existing with existing column error on Altering table
  480. Getting error whle changing the Datatype of a column in the table.
  481. When to use cursors?
  482. Migration from V8(solaris) to V9(redhat)
  483. normalizing two related tables
  484. How to specify the creator in db2connect
  485. Left outer join with case
  486. Dates, DB/2 and Java
  487. Query's Strange Behavior
  488. [IBM][CLI Driver][DB2/6000] SQL0952N - HELP
  489. DB2V8.2 DPF CPU Usage
  490. AS400JDBCDriver, encoding charset
  491. Issues when deploying applications on WebSpeher process server.
  492. [IBM][CLI Driver] SQL1284N The attempt to connect to database
  493. Query from more than 2 database
  494. Query from more than 2 database
  495. Please..need SHA1 implemented in DB2 version 8
  496. Need help on deleting log file (log_dir)
  497. UDF's crash after new CPU installation on AIX!
  498. set integrity
  499. The database manager is not able to accept new requests, has terminated all requests
  500. how to declare temp tables in a user-defined function
  501. Non-SOAP Web Service in DB2 9
  502. Event monitor that gives more lock info?
  503. Error Message Retreival in SQL Stored Procedures
  504. Applying CURRENT TIMESTAMP On Updates
  505. Db2
  506. What is the difference between BIND REPLACE and REBIND commands?
  507. Basic doubt in union.
  508. JDBC: Connected but no tables shown
  509. DB2 SQL Query
  510. timestamp
  511. Db2javit:rc=9505
  512. Delete table command in DB2 SQL ?
  513. db2 9 processes on linux.
  514. how to add a logical partition on the same computer.
  515. Replication : when asn.IBMSNAP_UOW is pruned ?
  516. BACKUP PENDING(Help me,Please)
  517. Inoperative packages vs. invalid packages
  518. Self Join in DB2 SQL
  519. Troubles using DB2, Websphere 3.5 and Java
  520. Effect of manually updating AVGCOMPRESSEDROWSIZE?
  521. is this table function possible for IBM DB2 v8.2?
  522. Mapping between Package and DBRM.
  523. JDBC type 4 driver for DB2 v7.1
  524. case and count
  525. SIMPLE but SLOW SELECT query!!!
  526. where do i declare the user temporary tablespace?
  527. temporary global tables
  528. Replication error
  529. functions that returns a table
  530. I cannot find License key
  531. Data Dictionary counterpart in DB2
  532. lock escalation : how "expensive"?
  533. INSERT Trouble
  534. How to create user Temporary table in DB2
  535. Migrate from v7 to v9, 32 to 64 bit
  536. How to Update Blob with JDBC?
  537. Generated Always As Identity
  538. COMPRLIB in backup
  539. Comparison of two rows in a table using SQL ?
  540. Setting a default schema for a particular group
  541. Removing a record from resultset using SQL
  542. Define tablespaces with different size paging into DB2
  543. Handling Null from a stored procedure
  544. truncate table for DB2 - differences
  545. Hosting Robots On Terminal Server
  546. Can Not Create Database - DAS Is Not Active
  547. what is a fully qualified table name in DB2 ?
  548. Script for db2 backup
  549. DB2 Trigger syntax
  550. DB2 Trigger syntax